Returns the first matching substring in the target value which matches the regular expression pattern.
Sample usage
REGEXP_EXTRACT(Campaign , 'TYPE:(.*)')
Syntax
REGEXP_EXTRACT(X, regular_expression)
Parameters
X- a field or expression that includes a field.-
regular_expression- a regular expression that extracts a portion offield_expression.regular_expressionmust contain a valid extraction pattern.
Returns
The REGEXP_EXTRACT function returns text values.
Example
Extract the top-level directory in a URL:
REGEXP_EXTRACT( URL , '^https://[^/]+/([^/]+)/' )For example, if the URL field contained this page's address, the function above would return looker-studio.
Notes
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.