[resolved] Strip Special Characters

[Anonymous]

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!

[Anonymous]

Hello
Read it as a string and replace it with "", for example:
tFileInputDelimited--row1--tMap--tOracleOutput
On tMap, type in the expression as below on the expression filed of column:
row1.columnName.replace("£","")
Best regards
shong

[Anonymous · Accepted solution]

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!