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 |