Problem reading Float from a CSV

Anonymous — Sat, 16 Nov 2024 14:18:55 GMT

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.

Re: Problem reading Float from a CSV

Anonymous — Tue, 01 Jul 2008 15:44:07 GMT

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

topic Re: Problem reading Float from a CSV in Talend Studio

Problem reading Float from a CSV

Re: Problem reading Float from a CSV