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

Five Stars

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

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

Moderator

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

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Thirteen Stars

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

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

 

 

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

Manohar B

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.