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

Data Studio uses the RE2 expression syntax. For more details, see [Regular Expressions in Data Studio](https://docs.cloud.google.com/data-studio/regular-expressions).

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](https://docs.cloud.google.com/data-studio/literals).

## Related resources

- [Regular expressions in Data Studio](https://docs.cloud.google.com/data-studio/regular-expressions)
- [Calculated fields](https://docs.cloud.google.com/data-studio/about-calculated-fields)
- [Data Studio function list](https://docs.cloud.google.com/data-studio/function-list)