FunctionsString

split_part

Splits the input by a delimiter and returns the 1-based field at the requested index. When the index is out of range, an empty string is returned.

split_part(…) → String

Kind · scalar

Splits the input by a delimiter and returns the 1-based field at the requested index. When the index is out of range, an empty string is returned.

Part of the String family.

split_by_whitespace

Splits each input string on contiguous whitespace runs and returns tokens as a JSON array string. Empty tokens are not emitted.

starts_with

Returns true when the input string begins with the provided prefix for each row.