Question:
Hi Matt and everyone,
I am using csv to process a csv data file form my customer. The file is not very large, about 4000 lines. It going well until CSV tried to slpit on a comma within a quoted block. My guess is that because there is a space on both sides of the comma, CSV assumed this was a new cell.
Here is a sample of the data. Please let me know what to do as a work-around.
Thanks, Erik
"...","LIFTING , PULLING OVER TIME","..." "...","Joe was bailing cardboard , slipped on cardboard and fell","..."
I tested using the latest version of Chilkat, and found no problem. Here's my test program:
CkCsv csv;const char *testName = "qa_csvCommaProblem"; csv.put_HasColumnNames(false); bool success = csv.LoadFile2("qa_data/csv/commaProblem.csv","utf-8"); if (!success) { printf("%s\n",csv.lastErrorText()); ReturnStatus(testName) } printf("NumRows = %d\n",csv.get_NumRows()); printf("%s\n",csv.getCell(0,0)); printf("%s\n",csv.getCell(0,1)); printf("%s\n",csv.getCell(0,2)); printf("%s\n",csv.getCell(1,0)); printf("%s\n",csv.getCell(1,1)); printf("%s\n",csv.getCell(1,2)); ReturnStatus(testName)