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