Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you upload a picture of the file import component properties.
Thanks
David
with CSV Options on, I get this result:
thx for the fast reply
HI,
What is the option set for "Text Enclosure" - for your data, it should be either """ (3 double quotes) or "\""
Thanks
David
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?
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