Returns the first position in the text value of any listed character (-1 if not found).
function (text as text, characters as list, optional occurrence as nullable any) as nullable any
Description
Returns the position of the first occurrence of any of the characters in the character list text found in the text value characters. An optional parameter occurrence may be used to specify which occurrence position to return.
Category
Text.Membership
Examples
Find the position of "W" in text "Hello, World!".
1
Text.PositionOfAny("Hello, World!", {"W"})
Copied!
7
Find the position of "W" or "H" in text "Hello, World!".