ENDS_WITH

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.

Notes

  • text is case-sensitive.
  • This function is equivalent to REGEXP_MATCH(X, ".*text$").

Examples

Example formula Data in Output
ENDS_WITH(Campaign, "Sale") Summer Sale true
ENDS_WITH(Campaign, "Summer") Summer Sale false

Related resources

Was this helpful?
How can we improve it?