topic Re: Remove Special Characters in Talend Studio

Remove Special Characters

Anonymous — Fri, 17 Jan 2014 13:25:47 GMT

Dear all,
I have an Excel file through which data for Column: Currency(String Data type) is coming like "0.12345"
now I want to put this value in Big decimal column : Main_Currency with value as 0.12345
Issue : I am unable to remove " " from "0.12345" .
Please suggest i to remove this special characters from this data.
I used => .replaceAll("","") but this removing my all decimal i.e. out put = 12345 and this removes "0." so this data is wrong.
Please guide me.
Thanks in advance.
Regards
RSH

Re: Remove Special Characters

Anonymous — Fri, 17 Jan 2014 21:09:59 GMT

My understanding is that the problem you are asking for help with is removing leading and trailing quotes from a string. If so, you may try:
TalendString.talendTrim("\"0.12345\"",'"',0)
If that is not the problem you are having can you clarify?

Re: Remove Special Characters

Anonymous — Mon, 20 Jan 2014 05:19:44 GMT

Dear Mike,
Thanks for your help as well as your time. Yes, your code helping me to get desired output.
Thanks again for your efforts.
Regards
RSH