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.


"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.

No comments:

Post a Comment