Text.PositionOfAny
Syntax
Text.PositionOfAny(text as text, characters as list, optional occurrence as nullable number) as any
About
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.
Example 1
Find the first position of "W" or "H" in text "Hello, World!".
Usage
Text.PositionOfAny("Hello, World!", {"H", "W"})
Output
0
Example 2
Find all the positions of "W" or "H" in text "Hello, World!".
Usage
Text.PositionOfAny("Hello, World!", {"H", "W"}, Occurrence.All)
Output
{0, 7}