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

• Calculated fields
• Data Studio function list