Check for Certain Text and remove from string

[Former Member]

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

[JWiseman · Accepted solution]

hi Mavis,

you can use the 'replace' function to do this...create a new formula with syntax similar to the following:

replace({your field},  "(InterCo)", "")

[abhilash_kumar]

Hi Mavis,

Use this code:

Replace({Company_Name}, "(InterCo)","")

-Abhilash

[Former Member]

Hi Both,

Thanks for the prompt respose.

The code works well!!!!!!!!