simple csv import

Four Stars

simple csv import

Hello,

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

grafik.png

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

grafik.png

Seven Stars

Re: simple csv import

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

 

Thanks

 

David

Regards

David

Don't forget to give Kudos when an answer is helpful or the solution.
Four Stars

Re: simple csv import

grafik.png

with CSV Options on, I get this result:

 

grafik.png

 

thx for the fast reply

 

Seven Stars

Re: simple csv import

HI,

 

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

 

Thanks

 

David

Regards

David

Don't forget to give Kudos when an answer is helpful or the solution.
Four Stars

Re: simple csv import

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

grafik.png

and tried the """ and "\""

 

grafik.png

and get a new error message

 

grafik.png

 

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

Seven Stars

Re: simple csv import

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

 

Capture.JPG

Regards

David

Don't forget to give Kudos when an answer is helpful or the solution.
Four Stars

Re: simple csv import