[resolved] Numberformat exception for input string : ""XXXX""

One Star

[resolved] Numberformat exception for input string : ""XXXX""

Hi,
I am reading data from a csv file and all the fileds are within double quotes.
In order to insert into DB when i try to do this ,
Integer.parseInt(row1.Column3)
I am getting the following error :-
Exception in component tMap_1
java.lang.NumberFormatException: For input string: ""2084377""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:481)
at java.lang.Integer.parseInt(Integer.java:527)

I tried using tReplace to replace the double quote but no luck.
Can anyone please help me?

Many Thanks,
Manju

Accepted Solutions
One Star

Re: [resolved] Numberformat exception for input string : ""XXXX""

Hi,
I could solve this by using StringHandling.CHANGE.

Thanks,
Manju

All Replies
One Star

Re: [resolved] Numberformat exception for input string : ""XXXX""

Hi,
I could solve this by using StringHandling.CHANGE.

Thanks,
Manju
Four Stars

Re: [resolved] Numberformat exception for input string : ""XXXX""

Can u explain me

Moderator

Re: [resolved] Numberformat exception for input string : ""XXXX""

Hello Sreenivas,

This is a quite old thread. We would suggest that you create a new topic in "Design and Development" and feel free to post your issue in it.

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.

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

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch