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 datastudio.
Notes
Data Studio uses the RE2 expression syntax. For more details, see Regular Expressions in Google Data Studio.
Note that patterns containing escape characters such as \ may require additional escaping in Data Studio, which can be avoided with the use of raw string literals.