FunctionsString

strpos

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

strpos(…) → UInt64

Kind · scalar

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

Part of the String family.

starts_with

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

substring

Extracts a substring using a 1-based start position and optional length argument, using byte offsets.