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
—String
pattern
—String
match_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.
Example
REGEXP_EXTRACT_NTH("RU 912 EN 873", "[A-Z]+\s+(\d+)", 2) = "873"
Data source support
ClickHouse 21.8
, MySQL 8.0.12
, Oracle Database 12c (12.1)
, PostgreSQL 9.3
.