Returns true if the field or expression ends with the specified text, otherwise returns false.
Sample usage
ENDS_WITH(Campaign, "Sale")
Syntax
ENDS_WITH(X, text)
Parameters
X- a field or expression of any type.text- the text to find within X.textcan be a field, expression, or literal value.textis case-sensitive.
Examples
| Example formula | Input | Output |
|---|---|---|
ENDS_WITH(Campaign, "Sale") |
Summer Sale | true |
ENDS_WITH(Campaign, "Summer") |
Summer Sale | false |