Text.PositionOfAny
Returns the first position in the text value of any listed character (-1 if not found).
Syntax
Text.PositionOfAny(
text as text,
characters as list,
optional occurrence as Occurrence.Type
) as any
Remarks
Returns the first position of any character in the list characters that is found in text. An optional parameter occurrence may be used to specify which occurrence position to return.
Examples
Example #1
Find the first position of "W" or "H" in text "Hello, World!".
Text.PositionOfAny("Hello, World!", {"H", "W"})
Result:
0
Example #2
Find all the positions of "W" or "H" in text "Hello, World!".
Text.PositionOfAny("Hello, World!", {"H", "W"}, Occurrence.All)
Result:
{0, 7}
Category
Text.Membership