topic Re: Issue in Expression Editor in Talend Studio

Issue in Expression Editor

dipanjan93 — Sat, 16 Nov 2024 07:18:52 GMT

Hello Community,

I have used the below logic to convert String datatype to Float inside Expression Builder of tMap -

(row36.Spillover_km3 == null || row36.Spillover_km3.isEmpty() == true)?0 :Float.valueOf(row36.Spillover_km3)

but I'm getting the below error -

Exception in component tMap_13
java.lang.NumberFormatException: empty String
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1842)
at sun.misc.FloatingDecimal.parseFloat(FloatingDecimal.java:122)
at java.lang.Float.parseFloat(Float.java:451)
at java.lang.Float.valueOf(Float.java:416)

Can anyone please let me know how to rectify this issue?

For reference I have attached the job screenshot.

Thanks in advance!

Best Regards.

Re: Issue in Expression Editor

manodwhb — Tue, 13 Nov 2018 11:53:28 GMT

@dipanjan93,

can you try the below one.

(row36.Spillover_km3 == null || ("").equals(row36.Spillover_km3))?0 :Float.valueOf(row36.Spillover_km3)

Re: Issue in Expression Editor

dipanjan93 — Tue, 13 Nov 2018 13:53:50 GMT

Hi @manodwhb

I have tried your approach but the issue still persists.

Re: Issue in Expression Editor

TRF — Tue, 13 Nov 2018 15:25:19 GMT

What about this one:

(row36.Spillover_km3 == null || 
 ("").equals(row36.Spillover_km3.replaceAll(" ", ""))) ? 0.0f : Float.valueOf(row36.Spillover_km3)

Re: Issue in Expression Editor

manodwhb — Wed, 14 Nov 2018 06:12:09 GMT

@dipanjan93,since you might have space issue use the below way.i have tested below one working as expected.

(row1.Col == null || ("").equals(StringHandling.TRIM(row1.Col)))?0 :Float.valueOf(row1.Col)

Re: Issue in Expression Editor

dipanjan93 — Wed, 14 Nov 2018 06:22:14 GMT

Hi @TRF

Nope still the issue persists. Although now something new has come up -

java.lang.NumberFormatException: For input string: "null"
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043)
at sun.misc.FloatingDecimal.parseFloat(FloatingDecimal.java:122)
at java.lang.Float.parseFloat(Float.java:451)
at java.lang.Float.valueOf(Float.java:416)

Re: Issue in Expression Editor

TRF — Wed, 14 Nov 2018 07:03:36 GMT

The field contains the string "null" (4 characters). Write line this:
(row36.Spillover_km3 == null || ("null").equalsIgnoreCase(row36.Spillover_km3 ||
("").equals(row36.Spillover_km3.replaceAll(" ", ""))) ? 0.0f : Float.valueOf(row36.Spillover_km3)

Re: Issue in Expression Editor

TRF — Thu, 15 Nov 2018 20:04:51 GMT

@dipanjan93, does this help?

If so, thanks to mark your case as solved (Kudos also accepted as a bonus)

Re: Issue in Expression Editor

dipanjan93 — Fri, 16 Nov 2018 01:24:42 GMT

Many Thanks @TRF and @manodwhb for your prompt response! It solved the issue.