topic [resolved] Strip Special Characters in Talend Studio

[resolved] Strip Special Characters

Anonymous — Sat, 16 Nov 2024 13:32:00 GMT

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!

Re: [resolved] Strip Special Characters

Anonymous — Fri, 26 Feb 2010 09:45:58 GMT

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

Re: [resolved] Strip Special Characters

Anonymous — Fri, 26 Feb 2010 15:23:51 GMT

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!