How to find out triple alphabets in one sentence.

[Rkaran001]

I am sharing some examples of the triple alphabet with attach files

[nagakavyasri]

Add a text input with possible triple alphabets and follow this:

[alisonpitt]

You can also do this with the Regex tool and a Formula tool.

Basically, you're identifying the tripled character, and then removing the triple value from the string.

Regex tool parse uses: ([a-zA-Z])\1\1

Formula tool uses [StringOut] + [StringOut] + [StringOut] to build the triple, then:

1. TRIM(REGEX_Replace([Name], [StringOut], '')) to edit the new name
2. REGEX_Replace([New Name], '\s+', ' ') to remove duplicate whitespace