Discussion Board for collaboration on QlikView Layout & Visualizations.
I want to know if there’s a function or a way to count how many times a char is repeated on a string
“aaa-bbb-ccc-ddd-eee” I want to count the ( - ) how manytimes in this example is 4
Go to Solution.
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
substringcount ( 'abcdefgcdxyz', 'cd' ) returns 2
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.
The answer is always into a good question.