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.

Related resources

Thông tin này có hữu ích không?

Chúng tôi có thể cải thiện trang này bằng cách nào?