topic simple csv import in Talend Studio

simple csv import

Anonymous — Sat, 16 Nov 2024 08:09:40 GMT

Hello,

I'm trying to import a csv File, which looks like this..

so i tryed to edit the schema for the first column to int, but get a

Couldn't parse value for column 'BookingID' in 'row1', value is '"21367234"'. Details: java.lang.NumberFormatException: For input string: ""21367234""
Couldn't parse value for column 'BookingID' in 'row1', value is '"21367546"'. Details: java.lang.NumberFormatException: For input string: ""21367546""...

I think because of the ""2136"",

but how to remove these extra ""?

Thanks very much

P.S:

I tried CSV Options with standard parameters, but then all i got is this

Re: simple csv import

David_Beaty — Mon, 04 Jun 2018 12:48:28 GMT

Can you upload a picture of the file import component properties.

Thanks

David

Re: simple csv import

Anonymous — Mon, 04 Jun 2018 13:31:21 GMT

with CSV Options on, I get this result:

thx for the fast reply

Re: simple csv import

David_Beaty — Mon, 04 Jun 2018 13:47:48 GMT

HI,

What is the option set for "Text Enclosure" - for your data, it should be either """ (3 double quotes) or "\""

Thanks

David

Re: simple csv import

Anonymous — Mon, 04 Jun 2018 13:58:35 GMT

I have put up a small version of the csv...

and tried the """ and "\""

and get a new error message

What are these "boxes" between the numbers e.g?

Re: simple csv import

David_Beaty — Mon, 04 Jun 2018 16:59:06 GMT

I have a similar tFileInputDelimited that works OK.

The only difference I can see is:

Escape char , """ (3 quotes)

Text Enclosure """ (3 quotes)

Note, my file has a different delimiter

Re: simple csv import

Anonymous — Mon, 04 Jun 2018 19:57:25 GMT

thx for the help
i removed the "" via powershell
https://blogs.technet.microsoft.com/heyscriptingguy/2011/11/02/remove-unwanted-quotation-marks-from-csv-files-by-using-powershell/