REGEXP_EXTRACT_NTH

    Syntax

    REGEXP_EXTRACT_NTH( string, pattern, match_index )
    

    Description

    Returns a substring string that matches the regular expression pattern pattern starting from the specified index.

    Argument types:

    • stringString
    • patternString
    • match_indexInteger

    Return type: String

    Note

    Only constant values are accepted for the arguments (pattern).

    Note

    See the documentation of the data source to clarify the regular expression syntax.

    Data source support

    ClickHouse 19.13, MySQL 8.0.12, PostgreSQL 9.3.