Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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 X 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
  • No labels