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