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

[#1]

Hi

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,

[#2 · Accepted 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

Example:

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

[stevelord]

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]

The answer is always into a good question.