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}
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for