Description
Determines whether a Text ends with a given Text.
Syntax
ENDSWITH(End Text, Text to Search [, Is Case Sensitive])
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| End Text (required) | Text | Any Dimensions | End text to find. |
| Text to Search (required) | Text | No Dimension or Dimensions of End Text | Text to search in. |
| Is Case Sensitive (optional) | Boolean | No Dimension or Dimensions of End Text | Whether the search is done with case sensitivity. By default, the search is not case sensitive. |
Returns
| Type | Dimensions |
|---|---|
| Boolean | Dimensions of End Text |
TRUE if Text to Search ends with End Text.
FALSE if Text to Search does not end with End Text.
Examples
| Formula | Result | Description |
|---|---|---|
ENDSWITH(“bc”, “abc”) | TRUE | The Text “abc” ends with “bc”. |
ENDSWITH(“b”, “abc”) | FALSE | The Text “abc” does not end with “b”. |
ENDSWITH(“C”, “abc”) | TRUE | The search is not case sensitive by default. Searching for the Text “C” is equivalent to searching for the Text “c”. |
ENDSWITH(“C”, “abc", TRUE) |
| The search is case sensitive. “abc” does not end with “C”. |
See also
Related articles: FIND, CONTAINS, STARTSWITH
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
