Replace special characters on multiple columns

[Anonymous]

Hi Shong,
I have a situation,
i am having source table which contains lots of special characters in multiple columns.
i handled for single column using tReplace component but its very lengthy to take every column in tReplace which contains Special characters.
Is there any other way to handle multiple columns at a time for special characters.
This is the list of Special Characters that i have in my data and Replace_By value for every special characters

Waiting for positive reply.
Thanks,
Shri_Kul1
Talend User

[Anonymous]

Hi  Shong & amolkhandare92 & dbh,
Thanks for your help,
Done with special characters issue. If you have multiple special characters in your source table and its issue for you then you can search them and put them in variable in tMap using 
column_name.replace("search_value","replace by_value")    as follows...
 row1.NAME.replace("?","").replace("&","").replace("¿","")
.replace("/n","").replace("nbsp;","").replace("á","")
.replace("ä", "").replace("?", "").replace("^", "")
.replace("*", "").replace("@", "").replace("`", "")
.replace("%", "").replace("#", "").replace("'", "")
.replace("\\'", "\\''")

[Anonymous]

Hi  Shong & amolkhandare92 & dbh,
Thanks for your help,
Done with special characters issue. If you have multiple special characters in your source table and its issue for you then you can search them and put them in variable in tMap using 
column_name.replace("search_value","replace by_value")    as follows...
 row1.NAME.replace("?","").replace("&","").replace("¿","")
.replace("/n","").replace("nbsp;","").replace("á","")
.replace("ä", "").replace("?", "").replace("^", "")
.replace("*", "").replace("@", "").replace("`", "")
.replace("%", "").replace("#", "").replace("'", "")
.replace("\\'", "\\''")