Text.EndsWith
Syntax
Text.EndsWith(text as nullable text, substring as text, optional comparer as nullable function) as nullable logical
About
Indicates whether the given text, text
, ends with the specified value, substring
. The indication is case sensitive.
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 comparison
- Comparer.OrdinalIgnoreCase: Used to perform an exact ordinal case-insensitive comparison
- Comparer.FromCulture: Used to perform a culture-aware comparison
Example 1
Check if "Hello, World" ends with "world".
Usage
Text.EndsWith("Hello, World", "world")
Output
false
Example 2
Check if "Hello, World" ends with "World".
Usage
Text.EndsWith("Hello, World", "World")
Output
true
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