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
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now