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:
string—Stringpattern—Stringmatch_index—Integer
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.
Previous
Next