topic Re: Conversion from string to float in Talend Studio

Conversion from string to float

Anonymous — Sat, 16 Nov 2024 13:49:20 GMT

Hi,
I am getting data in text format (positional format) and want to check if the string is null then assign 0.0 else divide the incoming string by 100
trying following expression but getting error "Exception in thread "main" java.lang.Error: Unresolved compilation problems:"
row2.fta_fare_amt.equals(null) ? Float.parseFloat("0.0")
: Float.parseFloat(row2.fta_fare_amt)
Unable to figure out what's the issue, need some help.
Thanks,
Milind

Re: Conversion from string to float

Anonymous — Mon, 17 Aug 2009 03:08:34 GMT

Hello Milind

row2.fta_fare_amt.equals(null) ? Float.parseFloat("0.0")
: Float.parseFloat(row2.fta_fare_amt)

Change it to

row2.fta_fare_amt==null?  Float.parseFloat("0.0")
: Float.parseFloat(row2.fta_fare_amt)

Best regards

shong

Re: Conversion from string to float

Anonymous — Mon, 17 Aug 2009 04:29:32 GMT

Hi Shong,
Here is the error I am getting after putting the code that you mentioned above
--
Exception in component tMap_9
java.lang.NumberFormatException: empty String
at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)
at java.lang.Float.parseFloat(Unknown Source)
--
where input string is string and output string is float , Do I need to change the datatype ?
Thanks,
Milind

Re: Conversion from string to float

Anonymous — Mon, 17 Aug 2009 04:38:42 GMT

Hello
This code should work fine

row2.fta_fare_amt==null||row2.fta_fare_amt.equals("")?  Float.parseFloat("0.0")
: Float.parseFloat(row2.fta_fare_amt)

Best regards

shong

Re: Conversion from string to float

Anonymous — Mon, 17 Aug 2009 05:13:01 GMT

Thanks Shong ... still the same error .. there is one more Int column, if following syntax correct, getting complilation error
row2.fta_chk_dgt_tkt_doc_nbr==null||row2.fta_chk_dgt_tkt_doc_nbr("")? Integer.parseInt("0")
: Integer.parseInt(row2.fta_chk_dgt_tkt_doc_nbr)
Thanks,
Milind

Re: Conversion from string to float

Anonymous — Mon, 17 Aug 2009 05:28:23 GMT

looks like the error is still for the float
Exception in component tMap_9
java.lang.NumberFormatException: empty String
at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)
at java.lang.Float.parseFloat(Unknown Source)
Thanks,
Milind

Re: Conversion from string to float

Anonymous — Mon, 17 Aug 2009 09:09:36 GMT

Hello guy

row2.fta_chk_dgt_tkt_doc_nbr==null||row2.fta_chk_dgt_tkt_doc_nbr("")? Integer.parseInt("0")

fta_chk_dgt_tkt_doc_nbr("")? ?????!!! please check your code, there is an error in your code.
Best regards
shong