SPLIT_PART

​

Syntax

​

Scalar

split_part(value, delimiter, part)

​

Arguments

​

Returns

• Type: STRING
• Possible values: The selected part, or an empty string when the part is out of range.
• NULL behavior: Returns NULL when any argument is NULL.

​

Properties

​

Usage notes

• An empty delimiter treats the whole input as one part.
• For a nonempty delimiter, a zero part number is treated as the first part only in the Snowflake branch; it raises an error in other dialects. With an empty delimiter, zero raises an error in every branch.

​

Examples

​

Typical behavior

SELECT split_part('a,b,c', ',', 2) AS middle, split_part('a,b,c', ',', -1) AS last;

​

Empty fields and a missing field

SELECT split_part('a,,c', ',', 2) AS empty_field, split_part('a,,c', ',', 4) AS missing_field;