You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » [resolved] Strip Special Characters
#1 2010-02-25 23:02:58
- jmaydon
- New member
- Registered: 2010-02-25
- Posts: 6
[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!
Offline
#2 2010-02-26 10:45:58
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
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#3 2010-02-26 16:23:51
- jmaydon
- New member
- Registered: 2010-02-25
- Posts: 6
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!
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » [resolved] Strip Special Characters