Remove special Characters from a column value

[joe86]

Hi Team,

I have a column which has special characters (includes different accents). I need to remove those characters from the string and send clean data to output. The data looks like below and i have to remove the highlighted:

"The is a sample data 

*éÉÇçÀà~@%#ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ/!@#$%?*()+ for your refernce"

The final output i want is "The is a sample data for your refernce".

Can someone please help me on how to remove it?? 

The data is in my DB and i need to UPDATE the column by removing the BAD DATA.

[Anonymous · Accepted solution]

Depending on your use case this will probably work.

data.replaceAll("[^a-zA-Z ]","")