How to remove inbetween characters from some records

[rkpatelqlikview]

Hi All,

Can anyone please help on this?

I need to remove only these type of data from some records.

I don't want see the data from bracket "(".

[prma7799]

Try this

=SubField(YourField,'(',1)

[karthikoffi27se]

Hi Kumar,

Please refer the below link

How to remove characters in between a string.

Many Thanks

Karthik

[rkpatelqlikview]

Thanks Karthik,

It removed some records but not all. still there are some records and generated duplicates as well.