Remove Special Characters

Four Stars RSH
Four Stars

Remove Special Characters

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
One Star

Re: Remove Special Characters

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?
Four Stars RSH
Four Stars

Re: Remove Special Characters

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. Smiley Happy
Regards
RSH