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

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



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

0 Kudos
2 Replies
AdrienL Dataiker
Dataiker
Re: How to Insert spaces in between abbreviations A.B.C. to A. B. C. and remove data in the last brackets

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).

0 Kudos
irafee1973
Level 1
Re: How to Insert spaces in between abbreviations A.B.C. to A. B. C. and remove data in the last brackets
noted with thanks.
0 Kudos
Labels (2)