Text.PositionOf(text as text, substring as text, optional occurrence as nullable number, optional comparer as nullable function) as any
Returns the position of the specified occurrence of the text value
substring found in
text. An optional parameter
occurrence may be used to specify which occurrence position to return (first occurrence by default). Returns -1 if
substring was not found.
Comparerwhich is used to control the comparison. Comparers can be used to provide case insensitive or culture and locale aware comparisons.
Comparer.Ordinal: Used to perform an exact ordinal comparison
Comparer.OrdinalIgnoreCase: Used to perform an exact ordinal case-insensitive comparison
Comparer.FromCulture: Used to perform a culture aware comparison
Get the position of the first occurrence of "World" in the text "Hello, World! Hello, World!".
Text.PositionOf("Hello, World! Hello, World!", "World")
Get the position of last occurrence of "World" in "Hello, World! Hello, World!".
Text.PositionOf("Hello, World! Hello, World!", "World", Occurrence.Last)