Text function: number of appearences in text

[#1]

Hi All,

what's the text function to get the number of of character set appearences in a text?

Regards,

Przemek

[swuehl · Accepted solution]

I believe you want to look into substringcount:

substringcount( text , substring)

Returns the number of times the string substring appears within the string text. The result is an integer. If there is no match, 0 is returned

Example:

substringcount ( 'abcdefgcdxyz', 'cd' ) returns 2

[#3]

Thank you, Stephan.