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.