Hi all,
I have a field which is the company name.
for example: ABC Pte Ltd (InterCo), ZXC Pte Ltd (InterCo)
What I need is to check all the company name which going to display is there "(InterCo)" at the end.
IF there is then will need to remove from the string before display.
Anyone can advise how can i do that?
Thanks in advance for the help.
Regards,
Mavis