Remove special Characters from a column value

joe86 — Tue, 11 Dec 2018 14:03:10 GMT

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.

Re: Remove special Characters from a column value

Anonymous — Tue, 11 Dec 2018 14:20:18 GMT

Depending on your use case this will probably work.

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

topic Re: Remove special Characters from a column value in Talend Studio

Remove special Characters from a column value

Re: Remove special Characters from a column value