split_part()

Reference: DuckDB 2.0.0

Arguments & returns

split_part(string, delimiter, position)

Macro
Overload link stringdelimiterposition Returns
#01 unknownunknownunknown unknown

Definition

"if" (
  (
    (string IS NOT NULL)
    AND ("delimiter" IS NOT NULL)
    AND ("position" IS NOT NULL)
  ),
  COALESCE(string_split(string, "delimiter") ["position"], ''),
  NULL
)

In other engines

Used in larger rewrites 1

These examples use split_part as one part of a larger SQL translation.

Snowflakesplit_part()

SELECT SPLIT_PART('11.22.33', '.', 2)
In DuckDB
SELECT CASE WHEN '.' = '' THEN (CASE WHEN (CASE WHEN 2 = 0 THEN 1 ELSE 2 END) = 1 OR (CASE WHEN 2 = 0 THEN 1 ELSE 2 END) = -1 THEN '11.22.33' ELSE '' END) ELSE SPLIT_PART('11.22.33', '.', (CASE WHEN 2 = 0 THEN 1 ELSE 2 END)) END

SQLGlot example โ†—