topic Count how many times a char is repeated on a string?? in QlikView

Count how many times a char is repeated on a string??

Tue, 01 May 2012 15:30:11 GMT

I want to know if there’s a function or a way to count how many times a char is repeated on a string

For example:

“aaa-bbb-ccc-ddd-eee” I want to count the ( - ) how manytimes in this example is 4

Thanks,

Tue, 01 May 2012 15:33:42 GMT

I Found the answerd

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

stevelord — Wed, 03 Dec 2014 21:19:26 GMT

Thanks, saved me from having to ask or go down the rabbit hole of a manual. Correct Answer points completely well-earned even when self-awarded.

Anonymous — Wed, 03 Dec 2014 22:02:08 GMT

The answer is always into a good question.