COUNTTEXT

Syntax

Evaluates the substring against the column and returns the number of matches. The function is case sensitive.

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