topic Re: Data_Type converstion Error in Talend Studio

Data_Type converstion Error

Talend_ent — Fri, 15 Nov 2024 23:55:46 GMT

Hi all,

I'm trying to convert integer column to string getting "java. lang.NumberFormatException: For input string:"

my input integer column is as follows

1234

4467

4646

opt:

1234

4467

4646

I tried with Integer.toString(row1.emp_num) it throwing Number format exception.

Any suggestions would be helpful

Thanks and Regards,

Talend_ent.

Re: Data_Type converstion Error

Talend_ent — Wed, 21 Jul 2021 04:40:26 GMT

The input column contains leading spaces.

Re: Data_Type converstion Error

gjeremy1617088143 — Wed, 21 Jul 2021 06:44:06 GMT

Hi, have you tried String.valueOf(row1.emp_num) ?

Send me Love and kudos

Re: Data_Type converstion Error

Talend_ent — Wed, 21 Jul 2021 06:47:35 GMT

@guenneguez jeremy yes, I tried with String.ValueOf() getting same error.

Re: Data_Type converstion Error

gjeremy1617088143 — Wed, 21 Jul 2021 06:58:30 GMT

with wich component do you read data ?

what is your data source (csv ,database,xml...)?

are you succeed in reading it as number ?

if it's csv for example just change the type of your column in the schema to string in tfileinputdelimited component

Re: Data_Type converstion Error

Talend_ent — Wed, 21 Jul 2021 07:14:17 GMT

@guenneguez jeremy my source is xml and I changed the datatype as a string it is working fine .

when I using datatype converstion in tMap getting null pointer exception here is my tmap expression

row1.emp_num.equals(null)||row1.emp_num==null?null:Integer.parseInt(row1.emp_num.trim());

any workaround.

Re: Data_Type converstion Error

gjeremy1617088143 — Wed, 21 Jul 2021 07:19:17 GMT

(row1.emp_num!=null && !row1.emp_num.equals("null"))?Integer.parseInt(row1.emp_num.trim()):null

(row1.emp_num!=null && !(row1.emp_num.replaceAll("\\D")).equals("") )?Integer.parseInt(row1.emp_num.trim()):null

for the second one i test null value then i look if when i delete all non digit char there is an empty value or not

Re: Data_Type converstion Error

Talend_ent — Wed, 21 Jul 2021 09:49:11 GMT

For the first expression it throwing null pointer exception. coming to the second one in replaceall method you're using single argument instead of two.

attachment shows the error for second expression.

Re: Data_Type converstion Error

gjeremy1617088143 — Wed, 21 Jul 2021 09:50:42 GMT

sorry my fault :

(row1.emp_num!=null && !(row1.emp_num.replaceAll("\\D","")).equals("") )?Integer.parseInt(row1.emp_num.trim()):null

Re: Data_Type converstion Error

Talend_ent — Wed, 21 Jul 2021 11:22:54 GMT

Again i'm getting java.lang.NullPointerException.

Re: Data_Type converstion Error

gjeremy1617088143 — Wed, 21 Jul 2021 12:17:22 GMT

couls you send some capture of the components , input flow ,input output schema of the component ?

cause I try with this in entry as string :

1234

4467

4646

opt:

1234

4467

4646

and in output int nullable

it works

result :

1234

4467

4646

null

1234

4467

4646

Re: Data_Type converstion Error

Talend_ent — Wed, 21 Jul 2021 15:34:50 GMT

Hi @guenneguez jeremy please find the attachments regarding job design and respective component configuration.

Re: Data_Type converstion Error

Talend_ent — Wed, 21 Jul 2021 15:37:23 GMT

Re: Data_Type converstion Error

Talend_ent — Wed, 21 Jul 2021 15:39:07 GMT

Re: Data_Type converstion Error

gjeremy1617088143 — Wed, 21 Jul 2021 16:16:51 GMT

Ok var1 is an int ,it doesn’t support null value, so set Integer instead of int in the schema of var1 and in the tmap output schema checked null for your int type of var1 field. it will transform it as Integer wich support null value.

Send me Love and Kudos