Text.PositionOfAny
Returns the first position in the text value of any listed character (-1 if not found).
function (text
as text,characters
as list, optionaloccurrence
as 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 4yr ago