Comment on page
Text.PositionOfAny
Returns the first position in the text value of any listed character (-1 if not found).
function (textas text,charactersas list, optionaloccurrenceas nullable any) as nullable any
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.Text.Membership
Find the position of "W" in text "Hello, World!".
Text.PositionOfAny("Hello, World!", {"W"})
7
Find the position of "W" or "H" in text "Hello, World!".
Text.PositionOfAny("Hello, World!", {"H","W"})
0
Last modified 5yr ago