[resolved] Strip Special Characters

One Star

[resolved] Strip Special Characters

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!

Accepted Solutions
One Star

Re: [resolved] Strip Special Characters

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!

All Replies
Community Manager

Re: [resolved] Strip Special Characters

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Strip Special Characters

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!