Remove un wanted data

[Rajareddy]

MY TABLE  Like 

input 

Id , name , country

001 ,raja , 788rrindia#$$

002, sunil , &&%USA788

output 

id , name , country

001 ,raja, india

002, sunil, USA

Thanks

raja

[AshutoshBhumkar]

Hi,

Try below. But you need to specify what is unwanted for you.

PurgeChar(country,'$#78%&')

Thanks,

Ashutosh

[abhijitnalekar]

Hi @Rajareddy ,

Is there any specific pattern in-country field?

as I can see there are extra letters with special characters.