CONTAINS_TEXT

Returns true if the specified text is found in the field or expression, otherwise returns false.

Sample usage

CONTAINS_TEXT(Campaign, "Sale")

Syntax

CONTAINS_TEXT(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 Input Output
CONTAINS_TEXT(Campaign, "Sale") Summer Sale true
CONTAINS_TEXT(Campaign, "discount") Summer Sale false

Related resources

Was this helpful?
How can we improve it?