Description
Splits a string into a bag around matches of a delimiter.
Syntax
STRSPLITTOBAG(string[, delimiter_regex[, limit]])
Arguments
string - input 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
STRSPLITTOBAG('Mary:had:a little:lamb',':',3)
returns a bag {Mary,had,a little:lamb}
Return value datatype
Bag
Impact of null value
If input is null, returns null.