Applies to: Databricks SQL Databricks Runtime
Extracts all of the strings in
str that match the
regexp expression and correspond to the
regex group index.
STRINGexpression to be matched.
STRINGexpression with a matching pattern.
idx: An optional integral number expression greater or equal 0 with default 1.
regexp string must be a Java regular expression.
When using literals, use `raw-literal` (`r` prefix) to avoid escape character pre-processing.
regexp may contain multiple groups.
idx indicates which regex group to extract.
idx of 0 means match the entire regular expression.