topic Re: [resolved] Numberformat exception for input string : ""XXXX"" in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 12:18:30 GMT

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

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

Anonymous — Tue, 24 Apr 2012 15:45:55 GMT

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

Thanks,
Manju

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

Sreenivas1 — Tue, 17 Apr 2018 10:30:22 GMT

Can u explain me

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

Anonymous — Thu, 19 Apr 2018 10:41:49 GMT

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