REGEXP_EXTRACT

The REGEXP_EXTRACT function creates dimension values by extracting them from a source dimension using Google RE2 regular expressions.

See the REGEXP_MATCH article for general information on regular expressions in Data Studio.

Sample usage

REGEXP_EXTRACT(Campaign , 'TYPE:(.*)')

REGEXP_EXTRACT(X, regular_expression)

X - a field or expression that includes a field.
regular_expression - a regular expression that extracts a portion of field_expression.

The REGEXP_EXTRACT function returns text values.

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.

Was this helpful?

How can we improve it?