COUNTMATCHES
- Juliane Wetzel
- Konsta Danyliuk (Deactivated)
Owned by Juliane Wetzel
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 |