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.text
can be a field, expression, or literal value.text
is case-sensitive.
Examples
Example formula | Input | Output |
---|---|---|
CONTAINS_TEXT(Campaign, "Sale") |
Summer Sale | true |
CONTAINS_TEXT(Campaign, "discount") |
Summer Sale | false |