Text & patterns
Scalar
regexp_extract_all()
Finds non-overlapping occurrences of the regex in the string and returns the corresponding values of the capturing group. A set of optional regex options can be set.
Reference: DuckDB 2.0.0
Arguments & returns
5 overloadsregexp_extract_all(string, regex)
Scalar
| Overload link | string | regex |
Returns |
|---|---|---|---|
| #01 | VARCHAR | VARCHAR |
VARCHAR[] |
regexp_extract_all(string, regex, group)
Scalar
| Overload link | string | regex | group |
Returns |
|---|---|---|---|---|
| #02 | VARCHAR | VARCHAR | INTEGER |
VARCHAR[] |
regexp_extract_all(string, regex, name_list)
Scalar
| Overload link | string | regex | name_list |
Returns |
|---|---|---|---|---|
| #03 | VARCHAR | VARCHAR | VARCHAR[] |
VARCHAR[] |
regexp_extract_all(string, regex, group, options)
Scalar
| Overload link | string | regex | group | options |
Returns |
|---|---|---|---|---|---|
| #04 | VARCHAR | VARCHAR | INTEGER | VARCHAR |
VARCHAR[] |
regexp_extract_all(string, regex, name_list, options)
Scalar
| Overload link | string | regex | name_list | options |
Returns |
|---|---|---|---|---|---|
| #05 | VARCHAR | VARCHAR | VARCHAR[] | VARCHAR |
VARCHAR[] |
Example
Haybarn WASM 2.0.0-rc12 Β· In your browser
Engine example Β· Run to view results.
In other engines
Snowflakeregexp_substr_all()
REGEXP_SUBSTR_ALL(subject, pattern)
REGEXP_EXTRACT_ALL(subject, pattern)