Stuck at CSV parsing: how to deal with empty row?
461036Dec 23 2005 — edited Dec 23 2005I've written page processes to deal with loading csv file contents to tables. The processes are similar to what were posted by Vikas on the forum before. (csv_to_array and upload blob content)
The CSV files were created by Saving windows Excel files as CSV types. Everything worked fine but empty rows. It seemed that the parser can't decide where is the correct ending of a row if it's empty. Although I tried different types of separators (chr13, chr10), the parsing failed as long as the Last column of a row was empty, which confused the parser of getting the right ending.
Any input is appreciated.