Double quotes should protect commas in data fields
complete
J
Jamie Papp
I have a customer sample inventory file that is throwing an error "Row#1 has incorrect number of fields. Fields: 162. Headers: 161. I have picked it apart, and if I remove the comma in the Part Description, it works.
The csv file has double quotes around the description ("GEO, PLE-SB-XXX"); however, DIM doesn't recognize the double quotes. It is reacting to the comma inside the quotes as a new field and not a comma within a description field, resulting in the number of fields as one greater than the number of headers.
DM me for the files that I cannot attach here. (Jamie Papp)
K
Kimberly Bellini
complete