Functions/Text & patterns/split_part
Text & patterns Macro

split_part()

Arguments & returns

split_part(string, delimiter, position)

Macro
Overload link stringdelimiterposition Returns
#01 unknownunknownunknown unknown

Definition

CASE
  WHEN (
    (
      (string IS NOT NULL)
      AND ("delimiter" IS NOT NULL)
      AND ("position" IS NOT NULL)
    )
  ) THEN (COALESCE(string_split(string, "delimiter") ["position"], ''))
  ELSE NULL
END

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 ↗