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
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?