Returns true
if the target value exactly matches the regular expression pattern.
Sample usage
REGEXP_MATCH(name, '[a-zA-Z].*')
Syntax
REGEXP_MATCH X
, regular_expression
)
Parameters
-
X- a field or expression to evaluate. -
regular_expression- a regular expression.
Returns
The REGEXP_MATCH
function returns Booleandata type values.
Notes
Looker Studio uses the RE2 expression syntax. For more details, see Regular expressions in Looker Studio .
Note that patterns that contain escape characters such as \
may require additional escaping in Looker Studio, although this can be avoided with the use of raw string literals
.
Examples
| Example formula | Input | Output |
|---|---|---|
REGEXP_MATCH(field_expression, 'A')
|
ABC123 | false |
REGEXP_MATCH(field_expression, 'A.*')
|
ABC123 | true |
REGEXP_MATCH(name, '[a-zA-Z].*')
|
Sam | true |
REGEXP_MATCH(name, '[a-zA-Z].*')
|
$am | false |
REGEXP_MATCH(country, '(USA|Canada|Mexico)')
|
Canada | true |
REGEXP_MATCH(country, '(USA|Canada|Mexico)')
|
Brazil | false |
