SPLIT

String functions

Syntax

SPLIT( orig_string, delimiter, part_index )

Description

Returns a substring from orig_string using the delimiter delimiter character to divide the string into a sequence of part_index parts.

Argument types:

• orig_string — String
• delimiter — String
• part_index — Number (whole)

Return type: String

Examples

SPLIT("RU-MOW-SVO", "-", 1) = "RU"

SPLIT("RU-MOW-SVO", "-", -1) = "SVO"

Data source support

Materialized Dataset, ClickHouse 1.1, MySQL 5.6, PostgreSQL 9.3