| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Extract all matches for a given regex pattern from a string.
Usage
...
details
Input
table
col |
|---|
random 123 text 456 test |
LQL Command
| Code Block |
|---|
select *, regexp_extract_array(col, '[a-z]+') as matches from table |
Output
col | matches |
|---|---|
random 123 text 456 test | WrappedArray(random, text, test) |