COUNTTEXT
Syntax
Description
Evaluates the substring against the column and returns the number of matches. The function is case sensitive.
Examples
Column | Substring | COUNTTEXT returns |
|---|---|---|
| Mississippi is a great state. | Mississippi | 1 |
| Mississippi | ss | 2 |
| Datameer X is making significant advances in big data analytics | data | 1 |
| Here she hops on a horse in Honduras | h | 3 |
| Here she hops on a horse in Honduras | H | 2 |