topic Re: Null Handling while String to Float in Talend Studio

Null Handling while String to Float

Anonymous — Thu, 20 Apr 2017 22:58:55 GMT

I have a column in data source that I am mandated to convert to float. The column contains words so need to replace them empty strings which I am doing as Variable.

row3.Estimated_Sales_Price.replace("REFUSED","").replace("N/A","").equals("") ? null : row3.Estimated_Sales_Price.trim()

then I am doing,

Var.var2 == null ? null : Float.parseFloat(Var.var2)

I am getting error: java.lang.NullPointerException. I have tried everything but all have proved to be futile.

Any insights anyone please!!!!!!!!!

Re: Null Handling while String to Float

TRF — Thu, 20 Apr 2017 23:06:26 GMT

Change to
row3.Estimated_Sales_Price == null || row3.Estimated_Sales_Price.replace("REFUSED","").replace("N/A","").equals("") ? null : row3.Estimated_Sales_Price.trim()

Re: Null Handling while String to Float

Anonymous — Thu, 20 Apr 2017 23:30:00 GMT

Would love to give you Kudos but the option has been disabled under your post for some odd reason.

Re: Null Handling while String to Float

TRF — Thu, 20 Apr 2017 23:45:36 GMT

Same on other topic. Kudos are available only for questions, not answers. Sound like a bug.
Come back later

Re: Null Handling while String to Float

TRF — Sat, 22 Apr 2017 21:07:58 GMT

Hi,

Kudos are back 🙂