Text & patterns Scalar

regexp_extract()

If string contains the regex pattern, returns the capturing group specified by optional parameter group; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional regex options can be set.

Arguments & returns

5 overloads

`regexp_extract(string, regex)`

Scalar

Overload link	`string`	`regex`	Returns
#01	`VARCHAR`	`VARCHAR`	`VARCHAR`

`regexp_extract(string, regex, group)`

Scalar

Overload link	`string`	`regex`	`group`	Returns
#02	`VARCHAR`	`VARCHAR`	`INTEGER`	`VARCHAR`

`regexp_extract(string, regex, name_list)`

Scalar

If string contains the regex pattern, returns the capturing groups as a struct with corresponding names from name_list; otherwise, returns a struct with the same keys and empty strings as values. A set of optional regex options can be set.

Overload link	`string`	`regex`	`name_list`	Returns
#03	`VARCHAR`	`VARCHAR`	`VARCHAR[]`	`VARCHAR`

`regexp_extract(string, regex, group, options)`

Scalar

Overload link	`string`	`regex`	`group`	`options`	Returns
#04	`VARCHAR`	`VARCHAR`	`INTEGER`	`VARCHAR`	`VARCHAR`

`regexp_extract(string, regex, name_list, options)`

Scalar

Overload link	`string`	`regex`	`name_list`	`options`	Returns
#05	`VARCHAR`	`VARCHAR`	`VARCHAR[]`	`VARCHAR`	`VARCHAR`