Community Conundrum 25:Feature Visualization is now live! Read 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)