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 X is making significant advances in big data analytics | Datameer X | advances | 2 |
| Here she hops on a horse in Honduras | h | 3 |
| Here she hops on a horse in Honduras | (?i)h | 5 |