Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Text function: number of appearences in text

Hi All,

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

Regards,

Przemek

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Text function: number of appearences in text

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

2 Replies
MVP
MVP

Text function: number of appearences in text

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

Not applicable

Text function: number of appearences in text

Thank you, Stephan.

Community Browser