Powered by GitBook

1 of 1

Loading...

regexpExtract

This section contains reference documentation for the regexpExtract function.

Extracts values that match the provided regular expression

Signature

regexpExtract(value, regexp)
regexpExtract(value, regexp, group)
regexpExtract(value, regexp, group, defaultValue)

Usage Examples

value

value

value

value

value

value

foo

123

foo

foo bar

bar

defaultValue

select regexpExtract('foo', '.*') AS value
from ignoreMe

select regexpExtract('foo123', '[0-9]+') AS value
from ignoreMe

select regexpExtract('foo123', '[^0-9]+') AS value
from ignoreMe

select regexpExtract('foo bar baz', '(\w+) (\w+)', 0) AS value
from ignoreMe

select regexpExtract('foo bar baz', '(\w+) (\w+)', 2) AS value
from ignoreMe

select regexpExtract('foo123', 'bar', 0, 'defaultValue') AS value
from ignoreMe