"Airplane 101","Super Entendere" ,"200","600"
Will return 2 columns whereas:
"Airplane 101","Super Entendere","200","600"
Will return the correct number of columns, 4.
Wednesday, 6 October 2010
DM-STX-0119 incorrect number of columns
DM-STX-0119 incorrect number of columns occurs when you load a .CSV where the items are comma delimited but also enclosed in quotes. DM mistakenly treats a blank space following the double quotes as an end of line and will report a reduced number of columns even though excel and other programs have no problem reading the file.
Will return 2 columns whereas:
Will return the correct number of columns, 4.
Will return 2 columns whereas:
Will return the correct number of columns, 4.
Subscribe to:
Posts (Atom)