Text.EndsWith

Search…
Text.EndsWith
Text.EndsWith
Indicates whether the text ends in the specified value.
function (optional text as nullable any, substring as text, optional comparer as nullable function) as nullable any
Description
Indicates whether the given text, text, ends with the specified value, substring. The indication is case-sensitive.
1
  <div>
2
    <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.
3
  </div>
4
  <div>
5
    The following built in comparers are available in the formula language:
6
  </div>
7
  <ul>
8
    <li><code>Comparer.Ordinal</code>: Used to perform an exact ordinal comparison</li>
9
    <li><code>Comparer.OrdinalIgnoreCase</code>: Used to perform an exact ordinal case-insensitive comparison</li>
10
    <li> <code>Comparer.FromCulture</code>: Used to perform a culture aware comparison</li>
Copied!
Category
Text.Membership
Examples
Check if "Hello, World" ends with "world".
1
Text.EndsWith("Hello, World", "world")
Copied!
false
Check if "Hello, World" ends with "World".
1
Text.EndsWith("Hello, World", "World")
Copied!
true
Text.End
Text.Format
Last modified 3yr ago
Copy link
Contents
Text.EndsWith
Description