trouble reading negative values from CSV files

[Anonymous]

Hello, 

I'm trying to load an Input CSV file into Mysql DB with two fields having numeric values. When I read the CSV file into Talend, negative values under one field are being read in brackets for eg: -100.00 as (100.00) whereas for the other field it doesn't do the same eg: -5.00 is being read as -5.00.

So, in Tmap when I'm forcing these string columns to convert into float values...it's not working as they have special characters. 

How do I read negative values into my database so that later when I group the numeric column by a particular dimension it has to take a sum of -ve & +ve values?

I'm thinking of using tReplace to replace "(" with "-" and ")" with "". Yet I'm not sure if I'd be able to convert "-644.00" to float datatype as it'll be still having "-" as a special character. 

Below I'm attaching screenshots of my tmap, job design, and input schema.

Thanks and regards,

Praneeth Reddy Varimalla

[vapukov]

Hi 

I think your problem just from thousands separator, you need to define it in the studio, on Advanced setting of tFileInputDelimited component