/
COUNTTEXT

COUNTTEXT

Jan 30, 2018

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

Column

Substring

 COUNTTEXT returns

Mississippi is a great state.

Mississippi

1

Mississippi

ss

2

Datameer 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