Text.EndsWith
Indicates whether the text ends in the specified value.
function (optionaltext
as nullable any,substring
as text, optionalcomparer
as nullable function) as nullable any
Indicates whether the given text,
text
, ends with the specified value, substring
. The indication is case-sensitive. <div>
<code>comparer</code> is a <code>Comparer</code> which is used to control the comparison. Comparers can be used to provide case insensitive or culture and locale aware comparisons.
</div>
<div>
The following built in comparers are available in the formula language:
</div>
<ul>
<li><code>Comparer.Ordinal</code>: Used to perform an exact ordinal comparison</li>
<li><code>Comparer.OrdinalIgnoreCase</code>: Used to perform an exact ordinal case-insensitive comparison</li>
<li> <code>Comparer.FromCulture</code>: Used to perform a culture aware comparison</li>
Text.Membership
Check if "Hello, World" ends with "world".
Text.EndsWith("Hello, World", "world")
false
Check if "Hello, World" ends with "World".
Text.EndsWith("Hello, World", "World")
true
Last modified 4yr ago