Apache Pinot Docs
latest
Search…
⌃K

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

select regexpExtract('foo', '.*') AS value
from ignoreMe
value
foo
select regexpExtract('foo123', '[0-9]+') AS value
from ignoreMe
value
123
select regexpExtract('foo123', '[^0-9]+') AS value
from ignoreMe
value
foo
select regexpExtract('foo bar baz', '(\w+) (\w+)', 0) AS value
from ignoreMe
value
foo bar
select regexpExtract('foo bar baz', '(\w+) (\w+)', 2) AS value
from ignoreMe
value
bar
select regexpExtract('foo123', 'bar', 0, 'defaultValue') AS value
from ignoreMe
value
defaultValue
Last modified 10mo ago