Join us, on May 27th, for an introduction to the new Dataiku Academy Learn more

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

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
Dataiker
Dataiker

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
Level 1
Author
noted with thanks.
0 Kudos
Labels (2)