topic Re: Remove un wanted data in Management & Governance

Remove un wanted data

Rajareddy — Tue, 05 Oct 2021 10:35:26 GMT

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 — Tue, 05 Oct 2021 10:44:29 GMT

Hi,

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

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

Thanks,

Ashutosh

abhijitnalekar — Tue, 05 Oct 2021 11:40:10 GMT

Is there any specific pattern in-country field?

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