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_stringString
    • delimiterString
    • part_indexNumber (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