How to eliminate continuous punctuation

Question

Hi,

Please suggest me a method/way that allows me to eliminate all punctuation (any type) if it appears more than once in a column.
For instance, K................................................... h........................a........................................n.......................................... I................................m............................................................d......................................................
In this instance, I want to maintain only one dot and eliminate the others, thus the result should be  => K.h.a.n.I.m.d.

Thank you!

Qiu · Answer

@DataNath 
Thanks for letting me that [:punct:] can represent the punctuations. 😁

DataNath · Answer

Hey @AKPWZ, here's one way you could look to handle this. We're just looking for a pattern of 2 or more punctuation characters and just replacing that with the first.

REGEX_Replace([Input], '([[:punct:]]){2,}', '$1')

Remove repeating punctuation.yxmd