SPLIT
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
Note
Only constant values are accepted for arguments (delimiter
).
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
.