topic Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format in Talend Studio

Empty String (Soruce data have the null value) error message when converting String to Decimal format

SMahadevan1608028474 — Fri, 22 Jan 2021 11:28:28 GMT

Source

-------

Product price

This is column is not mandatory and it have null values also in source data and it's reading the data as String.

Var

----

I have created with var Int datatype.

(int)(Double.parseDouble(row4.Product_price)*10000)

Output table - Set datatype as Double

-------------

Double.parseDouble(String.valueOf(Var.var2))/10000

So in Schemacompilance I have selected Nullable checkbox for this column.

After run the job since the source file as Null value am getting the below error,

java.lang.NumberFormatException: empty String

Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format

Peter_Mitchell — Fri, 22 Jan 2021 15:48:24 GMT

You're trying to parse a null or empty string to a double. Do something like this:

(row4.Product_price!=""||row4.Product_price!=null)?(int)(Double.parseDouble(row4.Product_price)*10000):null;

Even better, if you've got apache string utils installed I would do this:

Apache_string_utils.isBlank(row4.Product_price)?(int)(Double.parseDouble(row4.Product_price)*10000):null;

https://www.tutorialspoint.com/java/lang/double_parsedouble.htm

Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format

SMahadevan1608028474 — Fri, 22 Jan 2021 16:33:16 GMT

I have tried with this logics, but still facing the same issue "Empty String".

(row4.Product_price!=""||row4.Product_price!=null)?(int)(Double.parseDouble(row4.Product_price)*10000):null

Additionally this column(Product_price) has the negative value as well (Eg: -608).. I hope this will not make an issue.

Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format

SMahadevan1608028474 — Tue, 26 Jan 2021 17:17:17 GMT

Can anyone assist this ticket , I hope the logics seems to be correct . But still am facing the issue.

Attached the screenshot for more reference.

Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format

tnewbie — Tue, 26 Jan 2021 23:01:15 GMT

Did you try .equals(null) or !xxxx.equals(null), I have experienced this to be much better way of comparing nulls

Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format

SMahadevan1608028474 — Wed, 27 Jan 2021 09:13:14 GMT

I have tried the below ways, but still am facing the Empty String issue.

Can you please let me know is nay mistake here.

(row4.Unit_Selling_Price.equals(null)?null:(int)(Double.parseDouble(row4.Unit_Selling_Price)*10000))

(row4.Unit_Selling_Price!=(null)?(int)(Double.parseDouble(row4.Unit_Selling_Price)*10000):null)

(row4.Unit_Selling_Price.equals(null)||row4.Unit_Selling_Price!=(null)?(int)(Double.parseDouble(row4.Unit_Selling_Price)*10000):null)

Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format

Peter_Mitchell — Wed, 27 Jan 2021 09:29:26 GMT

A null string is not the same as an empty string. If you're going down the route of using .equals() method then you need to include an OR statement.

((row4.Unit_Selling_Price.equals(null) || row4.Unit_Selling_Price.equals("")) ? null : (int)(Double.parseDouble(row4.Unit_Selling_Price)*10000)).

As I said above, I would recommend using apache_string_utils.isBlank() method. Consistently works for me.

Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format

SMahadevan1608028474 — Wed, 27 Jan 2021 09:49:13 GMT

After trying this below statement,

((row4.Unit_Selling_Price.equals(null)||row4.Unit_Selling_Price.equals(""))?null:(int)(Double.parseDouble(row4.Unit_Selling_Price)*10000))

The below error is occurs,

Exception in component tMap_1 (Datavalidation_Filter_V1_3_tconvertype)

java.lang.NullPointerException

at datavalidation_jan11.datavalidation_filter_v1_3_tconvertype_0_1.Datavalidation_Filter_V1_3_tconvertype.tFileInputDelimited_1Process(Datavalidation_Filter_V1_3_tconvertype.java:52769)

at datavalidation_jan11.datavalidation_filter_v1_3_tconvertype_0_1.Datavalidation_Filter_V1_3_tconvertype.runJobInTOS(Datavalidation_Filter_V1_3_tconvertype.java:53952)

at datavalidation_jan11.datavalidation_filter_v1_3_tconvertype_0_1.Datavalidation_Filter_V1_3_tconvertype.main(Datavalidation_Filter_V1_3_tconvertype.java:53800)

[statistics] disconnected

I don't have apache string utils installed in my system and if I want to do that is the path is right on, please let me where can I download

https://commons.apache.org/proper/commons-lang/apidocs/org/apache/commons/lang3/StringUtils.html

Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format

tnewbie — Wed, 27 Jan 2021 17:01:32 GMT

Please try (row4.Unit_Selling_Price.equals("null")

Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format

SMahadevan1608028474 — Wed, 27 Jan 2021 17:16:53 GMT

I have tried this but still empty string error is occur,

(row4.Unit_Selling_Price.equals("null")?null:(int)(Double.parseDouble(row4.Unit_Selling_Price)*10000))

Re: Empty String (Soruce data have the null value) error message when converting String to Decimal format

SMahadevan1608028474 — Thu, 28 Jan 2021 12:01:13 GMT

Even I have tried with logics but the same error am getting,

Am trim the value even it is null and check the length of the column. Some time if you have any blank spaces it will workout the null condition check.

Please correct me if anything wrong here.

((StringHandling.TRIM(row4.Unit_Selling_Price).length()<=0)?null:(int)(Double.parseDouble(row4.Unit_Selling_Price)*10000))