regex_extract(regex, value)

regex_extract(regex, value) will try to parse value using the regular expression regex and extract the first captured group.

Superintendent follows Rust's regular expression syntax, which is heavily inspired by RE2.

Example 1

SELECT regex_extract('(?:[0-9]+)-([0-9]+)-([0-9])+', '2020-07-03') as extracted

returns:

extracted
07

Example 2

SELECT regex_extract('(?:[0-9]+)-([0-9]+)-([0-9])+', 'some random string') as extracted

returns:

extracted

Example 3

SELECT regex_extract('[a-zA-Z]+_([0-9]+)', 'GL_1234') as extracted

returns:

extracted
1234