Error in a Tmap : java.lang.NumberFormatException: For input string

[Anonymous]

Hi ,

While trying and loading the data in output database, i am getting below error:

Couldn't parse value for column 'CID' in 'row1', value is '"5"'. Details: java.lang.NumberFormatException: For input string: ""5""
Couldn't parse value for column 'CID' in 'row1', value is '"48"'. Details: java.lang.NumberFormatException: For input string: ""48""

PFA screenshots of tMap 

Please suggest the needful

[Anonymous · Accepted solution]

Hello,

The error "NumberFormatException: For input string:" usually occurs when Talend identifies inserting string value in the integer field. So make sure that if you are inserting the value form CSV file in to the field having data type as integer, it should not consist of string/character value or you can map the input column of CSV file to the field having data type as string.

Best regards

Sabrina

[manodwhb]

@anurag13_,i suggest you to convert sting to integer,if required apply replaceall function for " with space.

Integer.parseInt(row1.col.replaceAll(""",""))

[Anonymous]

Take a look at the this thread https://community.talend.com/t5/Design-and-Development/java-lang-NumberFormatException-error/td-p/81... or refer to https://domyhomeworkonline.net/ please.

[Anonymous]

<P>I found a step by step solution. Will share it in my next comment.

[AGoowar1664450028]

It is important for me to communicate with interesting people. I am glad to be able to receive extra help for my studies. I started using. It helps me to be better.