topic Re: Null handling for Integer,Float type in Talend Studio

Null handling for Integer,Float type

Anonymous — Wed, 31 May 2017 10:09:32 GMT

Hi everyone,

Can anyone say how to validate integer,float columns which have empty instead of the string "null"

I'm using below code but still, I'm getting an error like For input string: " "

I know in input one integer column is coming as empty.

Please help me to validate in the correct way.

Re: Null handling for Integer,Float type

vapukov — Wed, 31 May 2017 11:02:57 GMT

in advanced properties for input component - check Trim All column

excluding rare cases when spaces is mandatory it help a lot in many cases

Re: Null handling for Integer,Float type

Anonymous — Wed, 31 May 2017 11:33:36 GMT

You can try

yourStringData.matches("[-+]?\\d*\\.?\\d+")

Re: Null handling for Integer,Float type

Anonymous — Thu, 01 Jun 2017 07:45:28 GMT

Hi,

I'm getting below error after trying possible ways.

Exception in component tMap_1 (Local_Booking)
java.lang.NumberFormatException
at java.math.BigDecimal.parseExp(BigDecimal.java:647)
at java.math.BigDecimal.<init>(BigDecimal.java:488)
at java.math.BigDecimal.<init>(BigDecimal.java:383)
at java.math.BigDecimal.<init>(BigDecimal.java:806)
at np_old.local_booking_0_1.Local_Booking.tFileInputExcel_1Process(Local_Booking.java:3492)
at np_old.local_booking_0_1.Local_Booking.runJobInTOS(Local_Booking.java:4571)
at np_old.local_booking_0_1.Local_Booking.main(Local_Booking.java:4420)

Re: Null handling for Integer,Float type

Anonymous — Thu, 01 Jun 2017 07:55:03 GMT

Hi,

Here is the code I'm using for string to Bigdecimal

row1.ORDER_DISCOUNT.equals("null")?null:new BigDecimal(row1.ORDER_DISCOUNT)

Re: Null handling for Integer,Float type

vapukov — Thu, 01 Jun 2017 23:00:11 GMT

try this:

row1.ORDER_DISCOUNT==null||row1.ORDER_DISCOUNT.equals("")?null:new BigDecimal(row1.ORDER_DISCOUNT)

Re: Null handling for Integer,Float type

Anonymous — Fri, 02 Jun 2017 09:35:31 GMT

Hi @vapukov & @h311,

Thanks for your help.

It's working 🙂

Re: Null handling for Integer,Float type

Anonymous — Fri, 02 Jun 2017 09:42:44 GMT

Here is a routine you can use......

    public static boolean isNumeric(String data){
    	boolean returnVal = true;
    	
    	try{
    		Integer.parseInt(data);
    	}catch(Exception ex){
    		returnVal = false;
       	}
    	return returnVal;
    }

I use that to test if String values represent Integers. Just tweak the code to cater for Floats if you need to. It will return true or false based on what you supply the String parameter