Data Studio is now Looker Studio. Looker Studio is still free, with the same features you already know. Looker Studio Pro offers improved asset management for enterprises, new team collaboration capabilities, and access to technical support. Learn more.

REGEXP_CONTAINS

Returns true if a piece of text is a partial match for the regular expression.

Sample usage

REGEXP_CONTAINS(Page, 'home')

Syntax

REGEXP_CONTAINS(X, regular_expression)

Parameters

  • X - a field or expression to evaluate.
  • regular_expression - a regular expression.

Returns

The REGEXP_CONTAINS function returns boolean values.

Notes

This function returns true if value X or any substring thereof matches for the pattern regular_expression. For example, if the value of Field is "ABC123":

REGEXP_CONTAINS(Field, 'A') returns true.
REGEXP_CONTAINS(Field, 'A.*') returns true.
REGEXP_CONTAINS(Field, 'AC') returns false.

REGEXP_CONTAINS differs from the similar REGEXP_MATCH function, which will only match the entire value by default. Thus, REGEXP_CONTAINS(field,"pattern") is functionally equivalent to REGEXP_MATCH(field,".*pattern.*).

Looker Studio uses the RE2 expression syntax. For more details, see Regular Expressions in Looker Studio.

Note that patterns containing escape characters such as \ may require additional escaping in Looker Studio, which can be avoided with the use of raw string literals.

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
true
false
true
true
102097
false
false