COUNTMATCHES
Syntax
COUNTMATCHES(<string>;<string with regex>)
Description
Evaluates the regular expression against the column and returns the number of matches. The function is case sensitive.
Examples
Column | Regular expression | COUNTMATCHES returns |
|---|---|---|
Mississippi is a great state. | Mississippi | 1 |
Mississippi | [^s] | 7 |
Datameer is making significant advances in big data analytics | Datameer | advances | 2 |
Here she hops on a horse in Honduras | h | 3 |
Here she hops on a horse in Honduras | (?i)h | 5 |