You are not logged in.
When I put row1.columnName.replace("£","") in tMap and re-ran the job it didn't work at first. I went back and changed the Encoding type on the file to Window - 1252 and it worked. Thanks for the help!
Read it as a string and replace it with "", for example:
On tMap, type in the expression as below on the expression filed of column:
I am new to Talend and trying to strip special characters from my files before they get into Oracle. I can do this with all characters except the Euro £. It shows up in my database as ¿. I've added both of these characters to our routine to strip special characters but it doesn't pick it up. Any help would be greatly appreciated!