topic Re: [Tmap Error] NumberFormatException: For input string in Talend Studio

[Tmap Error] NumberFormatException: For input string

RA6 — Sat, 16 Nov 2024 08:09:46 GMT

Hello,

There's a simple job below:

Here is my input csv:

My Tmap in details:

Condition1 is working well which remove space and replace comma with dot and null to "0:

row1.newColumn1==null | row1.newColumn1.equals("")?"0":
row1.newColumn1.contains(",")?row1.newColumn1.replace(",", "."):
row1.newColumn1.contains(" ")?row1.newColumn1.replace(" ", ""):
row1.newColumn1

Condition2 is working well too (same as condition one)

row1.newColumn2==null | row1.newColumn2.equals("")?"0":
row1.newColumn2.contains(",")?row1.newColumn2.replace(",", "."):
row1.newColumn2.contains(" ")?row1.newColumn2.replace(" ", ""):
row1.newColumn2

Condition3: ERROR found: (Trying to keep value to two decimal place and of type string)

String.format("%.5f", (Double.parseDouble(Var.var1) - Double.parseDouble(Var.var2)))

Tried hard but couldn't identify the issue.

Can you advice please?

Thank you very much.

Re: [Tmap Error] NumberFormatException: For input string

manodwhb — Mon, 04 Jun 2018 10:36:36 GMT

@asadasing,cant you try to convet to Float instead of Double,your issue will be resloved.

example:-

Float.parseFloat()

Re: [Tmap Error] NumberFormatException: For input string

RA6 — Mon, 04 Jun 2018 11:51:45 GMT

Do you know the reason of this error?
It was working fine before.

Re: [Tmap Error] NumberFormatException: For input string

RA6 — Mon, 04 Jun 2018 12:18:52 GMT

The solution you provided is not working.

I have tried to convert using float and encountering same error.

Float.valueOf(String)

And also

Float.parseFloat(String)

Can you advice please?

Re: [Tmap Error] NumberFormatException: For input string

manodwhb — Mon, 04 Jun 2018 13:04:50 GMT

@asadasing,your have space or tab between 1 and 4 of 1 430.76. becuase of the your were getting error,you nee to replace that with empty.

Re: [Tmap Error] NumberFormatException: For input string

manodwhb — Mon, 04 Jun 2018 13:20:39 GMT

@asadasing,can you re-write cloumn1 and cloumn2,variable expressions as below.should work if you have space issue.

row3.newColumn2==null | row3.newColumn2.equals("")?"0"row3.newColumn2.replace(",",".")).replace(" ","")

Re: [Tmap Error] NumberFormatException: For input string

RA6 — Mon, 04 Jun 2018 14:05:22 GMT

This one works fine.

Indeed the contain function (.contain) was not working OR it could not recognize the space in the string.

Thank you very much. Issue marked as solved.

Best regards,

asadasing