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