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

[Anonymous]

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

[Anonymous · Accepted solution]

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

Thanks,
Manju

[Sreenivas1]

Can u explain me

[Anonymous]

Hello ,

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