Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try below. But you need to specify what is unwanted for you.
PurgeChar(country,'$#78%&')
Thanks,
Ashutosh
Hi @Rajareddy ,
Is there any specific pattern in-country field?
as I can see there are extra letters with special characters.