ETL: STRSPLIT

Split a string into a tuple of substrings using a specified delimiter character. Use STRSPLIT for parsing delimited text data in ETL pipelines.

Description

Splits a string into a tuple around matches of a delimiter.

Syntax

STRSPLIT(string[, delimiter_regex[, limit]])

Arguments

string - string expression

delimiter_regex - regular expression string delimiter. Optional with default ‘\s’.

limit - integer indicating the number of times the regular expression pattern is applied. Optional with default 0.

Examples

STRSPLIT('Mary:had:a little:lamb',':',3) returns a tuple (Mary,had,a little:lamb)

STRSPLIT('Mary:had:a little:lamb',':',3).$0 returns a string Mary

STRSPLIT('Mary:had:a little:lamb',':',3).$1 returns a string had

Return value datatype

Tuple

Impact of null value

If input is null, returns null.