str_split_regex()

Splits the string along the regex

Arguments & returns

2 overloads

Scalar

Overload link	`string`	`regex`	Returns
#01	`VARCHAR`	`VARCHAR`	`VARCHAR[]`

Scalar

Overload link	`string`	`regex`	`col2`	Returns
#02	`VARCHAR`	`VARCHAR`	`VARCHAR`	`VARCHAR[]`

SELECT str_split_regex('hello world; 42', ';? ');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  string_split_regex('hello world; 42', ';? ');

SELECT SPLIT('123|789', '\\|')

In DuckDB

SELECT STR_SPLIT_REGEX('123|789', '\|')

splitByRegexp('\\d+', x)

In DuckDB

STR_SPLIT_REGEX(x, '\d+')

REGEXP_SPLIT(x, 'a.')

In DuckDB

STR_SPLIT_REGEX(x, 'a.')