COUNTTEXT

Syntax

COUNTTEXT(<string>;<string>)

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

Mississippiss2
Datameer is making significant advances in big data analyticsdata

1

Here she hops on a horse in Hondurash3
Here she hops on a horse in HondurasH2