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