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. 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

Related resources

• Calculated fields
• Looker Studio function list