How to Insert spaces in between abbreviations A.B.C. to A. B. C. and remove data in the last brackets

[irafee1973]

Ive followed Adriens advise and added \b([A-Z]\.)(?=[A-Z]\b) and $1 but it does not seem to work.

The second question is to remove data that occurs in paranthesis at the end. For example

AIRGUARD ASIA SDN BHD (429729-V) to AIRGUARD ASIA SDN BHD by using \(.*\)$ works if there are no other brackets but if the data is like this: AIWA ELECTRONICS (MALAYSIA) SDN BHD (182191-W), using \(.*\)$ returns AIWA ELECTRONICS, but what I actually want is AIWA ELECTRONICS (MALAYSIA) SDN BHD

thanks in advance

[AdrienL]

This Answers website is dedicated to generic questions about Dataiku DSS. For specific usage questions, please use intercom (the bottom-right chat on the dataiku.com website).

[irafee1973]

noted with thanks.