Text.EndsWith(text as nullable text, substring as text, optional comparer as nullable function) as nullable logical
Indicates whether the given text,
text, ends with the specified value,
substring. The indication is case-sensitive.
Comparerwhich 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
Check if "Hello, World" ends with "world".
Text.EndsWith("Hello, World", "world")
Check if "Hello, World" ends with "World".
Text.EndsWith("Hello, World", "World")