regexp_count
function
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above
Returns the number of times str
matches the regexp
pattern.
Returns
An INTEGER
.
The regexp
string must be a Java regular expression.
String literals are unescaped. For example, to match '\abc'
, a regular expression for regexp
can be '^\\abc$'
.
In case of a malformed regexp
the function returns an INVALID_PARAMETER_VALUE error.
If either argument is NULL
, the result is NULL
.