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

Highlighted
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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads