REGEXP_EXTRACT

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 of X. regular_expression must contain a valid extraction pattern.

Returns

The REGEXP_EXTRACT function returns Text data type values.

Example

Example formula Input Output
REGEXP_EXTRACT( URL, '\^https://\[\^/\]+/(\[\^/\]+)/' ) https://support.google.com/looker-studio/answer/7050487 looker-studio
REGEXP_EXTRACT( URL, '\^https://\[\^/\]+/(\[\^/\]+)/' ) https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators bigquery

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.