Functions/Text & patterns/string_split_regex
Text & patterns Scalar

string_split_regex()

Splits the string along the regex

Arguments & returns

2 overloads

string_split_regex(string, regex)

Scalar
Overload link stringregex Returns
#01 VARCHARVARCHAR VARCHAR[]

string_split_regex(string, regex, col2)

Scalar
Overload link stringregexcol2 Returns
#02 VARCHARVARCHARVARCHAR VARCHAR[]

Example

string_split_regex example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Used in larger rewrites 1

These examples use string_split_regex as one part of a larger SQL translation.

Snowflakeregexp_instr()

SELECT REGEXP_INSTR(subject, pattern)
In DuckDB
SELECT CASE WHEN subject IS NULL OR pattern IS NULL THEN NULL WHEN pattern = '' THEN 0 WHEN LENGTH(REGEXP_EXTRACT_ALL(subject, pattern)) < 1 THEN 0 ELSE 1 + COALESCE(LIST_SUM(LIST_TRANSFORM(STRING_SPLIT_REGEX(subject, pattern)[1:1], x -> LENGTH(x))), 0) + COALESCE(LIST_SUM(LIST_TRANSFORM(REGEXP_EXTRACT_ALL(subject, pattern)[1:1 - 1], x -> LENGTH(x))), 0) + 0 END

SQLGlot example ↗