Text.PositionOfAny

Remarks

Text.PositionOfAny searches text for any character that appears in the characters list and returns the position of the first such match. Returns -1 if no character from the list is found — not an error. Like Text.PositionOf, always check for -1 before using the result as an offset.

The characters parameter is a list of single-character text values. Each element is matched independently as a single character, not as a substring. This is the key difference from Text.PositionOf, which searches for a multi-character substring. Use Text.PositionOfAny when you want to find the first occurrence of any one of a set of characters — for example, the first digit, the first punctuation character, or the first whitespace.

The optional occurrence parameter accepts: - Occurrence.First (default) — position of the first matching character - Occurrence.Last — position of the last matching character - Occurrence.All — a list of all positions where any matching character appears

Note that Text.PositionOfAny does not accept a comparer parameter — the character matching is always case-sensitive. To perform case-insensitive matching, normalize the text with Text.Lower or Text.Upper before calling this function, and also lowercase or uppercase your characters list accordingly.