COUNTMATCHES

Syntax

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

Description

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

Examples

Column

Regular expression

 COUNTMATCHES returns

Mississippi is a great state.Mississippi

1

Mississippi[^s]7
Datameer X is making significant advances in big data analyticsDatameer X | advances

2

Here she hops on a horse in Hondurash3
Here she hops on a horse in Honduras(?i)h5