str_split()

Splits the string along the separator.

Arguments & returns

Scalar

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

SELECT str_split('hello-world', '-');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

splitByString('s', x)

In Haybarn

STR_SPLIT(x, 's')

SPLIT(x, 'a.')

In Haybarn

STR_SPLIT(x, 'a.')

Used in larger rewrites 1

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

SELECT SPLIT('127.0.0.1', '.')

In Haybarn

SELECT CASE WHEN '.' IS NULL THEN NULL WHEN '.' = '' THEN ['127.0.0.1'] ELSE STR_SPLIT('127.0.0.1', '.') END