COUNTMATCHES

Syntax

COUNTMATCHES(<string>;<string with regex>)

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

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