topic Re: Error Tmap String to float in Talend Studio

Error Tmap String to float

Anonymous — Sat, 16 Nov 2024 04:46:01 GMT

Hello,

I'm new at talend and i'm trying to convert string to float and i facing many issues.

The tConvertType is not working for me, give me this error

For input string: "1,37"
For input string: "1,37"
For input string: "1,37"
For input string: "1,37"
For input string: "1,37"
For input string: "1,37"
For input string: "0,72"
For input string: "0,72"
For input string: "0,72"
For input string: "0,72"
For input string: "0,72"
For input string: "0,72"

For input string: "1.000,72"

Yes, my input data source is a string with "." and ",".

Now, i'm trying with the tMap

using the expression below : Float.parseFloat(StringHandling.EREPLACE(row1.KUS,",","."))

but stil not working

error

Exception in component tMap_2 (Transform_MetaDados)
java.lang.NumberFormatException: multiple points
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1914)
at sun.misc.FloatingDecimal.parseFloat(FloatingDecimal.java:122)
at java.lang.Float.parseFloat(Float.java:451)
at extract_to_oracledb.transform_metadados_0_1.Transform_MetaDados.tDBInput_2Process(Transform_MetaDados.java:1474)
at extract_to_oracledb.transform_metadados_0_1.Transform_MetaDados.runJobInTOS(Transform_MetaDados.java:2144)
at extract_to_oracledb.transform_metadados_0_1.Transform_MetaDados.main(Transform_MetaDados.java:1994)

Re: Error Tmap String to float

David_Beaty — Thu, 05 Sep 2019 12:56:40 GMT

Hi,

I'd suggest you do this as a series of steps in the tMap Var section:

1/ String in -> remove the dots (1.000,72) -> (1000,72)

2/ Step 1 String in -> convert the commas to dots (1000,72) -> (1000.72)

3/ Step 2 String in -> parse string to float.

Thanks

Re: Error Tmap String to float

Anonymous — Thu, 05 Sep 2019 13:51:01 GMT

How is the better way to remove the dots

I'm trying this

StringHandling.EREPLACE(row1.KUS,"."," ")

Exception in component tMap_4 (Transform_MetaDados)
java.lang.NumberFormatException: empty String
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1842)
at sun.misc.FloatingDecimal.parseFloat(FloatingDecimal.java:122)

Re: Error Tmap String to float

Anonymous — Thu, 05 Sep 2019 14:14:42 GMT

hello,

you can try this:-

Float.parseFloat(row1.myString)

thanks,

Warm Regards,
Manish

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Error Tmap String to float

guratalgura — Thu, 05 Sep 2019 14:19:29 GMT

Hi,

try this:

Float.parseFloat(StringHandling.EREPLACE(StringHandling.EREPLACE(row1.KUS,"\\.",""),",","\\."))

Regards

Re: Error Tmap String to float

Anonymous — Thu, 05 Sep 2019 18:24:39 GMT

Perferct! Thanks, this working for me..

But in other columns i'm facing another issue, probaly because i have null values.

i tried this expression

row2.QTDE_REC_2.equals("null")0:Float.parseFloat(StringHandling.EREPLACE(StringHandling.EREPLACE(row2.QTDE_REC_2 ,"\\.",""),",","\\."))

AND RECEIVE THIS ERROR :

Exception in component tMap_2 (Transform_MetaDados)
java.lang.NullPointerException
at extract_to_oracledb.transform_metadados_0_1.Transform_MetaDados.tDBInput_2Process(Transform_MetaDados.java:2207)
at extract_to_oracledb.transform_metadados_0_1.Transform_MetaDados.runJobInTOS(Transform_MetaDados.java:3032)
at extract_to_oracledb.transform_metadados_0_1.Transform_MetaDados.main(Transform_MetaDados.java:2882)

Could you suggest something diferent ?

I'm aprecciente your help

Re: Error Tmap String to float

guratalgura — Fri, 06 Sep 2019 10:37:05 GMT

Hi,

You can use the ternary oparator to check the null or empty row before formatting

try this :

(row2.QTDE_REC_2 != null && !row2.QTDE_REC_2.isEmpty()) ? Float.parseFloat(StringHandling.EREPLACE(StringHandling.EREPLACE(row2.QTDE_REC_2,"\\.",""),",","\\.")): 0

Regards,