Text.PositionOf
Syntax
Text.PositionOf(text as text, substring as text, optional occurrence as nullable number, optional comparer as nullable function) as any
About
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.
comparer
is a Comparer
which is used to control the comparison. Comparers can be used to provide case-insensitive or culture and locale-aware comparisons.
The following built-in comparers are available in the formula language:
Comparer.Ordinal
: Used to perform an exact ordinal comparisonComparer.OrdinalIgnoreCase
: Used to perform an exact ordinal case-insensitive comparisonComparer.FromCulture
: Used to perform a culture-aware comparison
Example 1
Get the position of the first occurrence of "World" in the text "Hello, World! Hello, World!".
Usage
Text.PositionOf("Hello, World! Hello, World!", "World")
Output
7
Example 2
Get the position of last occurrence of "World" in "Hello, World! Hello, World!".
Usage
Text.PositionOf("Hello, World! Hello, World!", "World", Occurrence.Last)
Output
21
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