topic Re: How can i Convert a row containing the float value (6.60) into the -6.60 in Talend Studio

How can i Convert a row containing the float value (6.60) into the -6.60

Anonymous — Wed, 08 Aug 2018 08:28:55 GMT

I have a "*.csv" file with comma separated, containing a row of data type 'FLOAT' with value '(6.60)' , i have to convert this row into '-6.60'

How can i convert this?

Re: How can i Convert a row containing the float value (6.60) into the -6.60

Anonymous — Wed, 08 Aug 2018 14:43:57 GMT

You Can use Mathematical.NEG function it will Returns the arithmetic additive inverse of the value of the argument.

Re: How can i Convert a row containing the float value (6.60) into the -6.60

manodwhb — Thu, 09 Aug 2018 09:07:16 GMT

@meetmahajan,convert float to sting and add "-" before the float to sting expression.

Re: How can i Convert a row containing the float value (6.60) into the -6.60

Anonymous — Thu, 09 Aug 2018 09:26:49 GMT

Thanks both the solutions working perfectly.

Conversion Syntax : Mathematical.NEG(Double.parseDouble(Variable.replaceAll("\\(", "").replaceAll("\\)","").trim()))