Hello,
I have a series of text fields, which I need to clean of all full stops. The input text is company names, which sometimes contain abbreviations and sometimes full stops for other reasons.
I would like to remove the full stops when the text is an abbreviation, otherwise, I would like to replace it with a space. I would define an abbreviation as a series of pairs of a single alphabetical character followed by a full stop.
Example inputs and desired outputs:
input --> Desired Output
U.K. --> UK
E.U. --> EU
bank.of --> bank of
help.co.uk --> help co uk
Would anybody know of a regex or other method which could help me to identify the full stops I wish to remove rather than replace?
Thanks!!!