simple csv import

[Anonymous]

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

[David_Beaty]

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

Thanks

David

[Anonymous]

with CSV Options on, I get this result:

thx for the fast reply

[David_Beaty]

HI,

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

Thanks

David

[Anonymous]

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?

[David_Beaty]

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

[Anonymous]

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