Problem reading Float from a CSV

Hello,
I am actually trying to parse a CSV file containing french format float (comma instead of dot -> "1,99")
To manage those floats, I tried to use Strings, the function EREPLACE and then to cast them into floats.
But an error occurs when casting an empty string.
Do you have any solution for this problem ?
I was thinking about Talend being able to automatically manage french format float, but I didn't find anything about it.
Regards,
Damien.
1 REPLY
One Star

Re: Problem reading Float from a CSV

Hello,
You just have to go to your fileInput component properties -> advanced setting and check "advanced separator" and change Decimal and Thousand separator.
JC.