Finding maximum occurrence of a character in a string

[SureshUK]

Hi,

Is there a way of finding maximum occurrence of a character in a given string?

Example: In the string "RAGR", "R" has occurred twice.

The string will always have just one character occurring multiple times and there won't be any stalemate.

Thanks.

[sunny_talwar]

Didn't you mention that there will only be one character repeating?

"The string will always have just one character occurring multiple times and there won't be any stalemate."

Checking now

[sunny_talwar]

This will work for numbers, but not text

=Left(Trim(Concat(DISTINCT Mid(Field, ValueLoop(1, 100), 1), '', -(SubStringCount(Field, Mid(Field, ValueLoop(1, 100), 1))*100 + Alt(Mid(Field, ValueLoop(1, 100), 1), 0)))), 1)

[SureshUK]

Thanks Sunny. This works!

[sunny_talwar]

Super, but remember this may or may not work for string character.... that might need some more modifications. Would you need that?