FunctionsString

starts_with

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

starts_with(…) → Bool

Kind · scalar

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

Part of the String family.

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.

strpos

Returns the 1-based byte position of the first substring occurrence. Returns 0 when no match is found.