Microsoft Excel 2003 (or at least the copy I was stuck with) had a weird bug where if the final column of a CSV spreadsheet with headers was empty (column header there but no data) then the outputted CSV file would only contain the correct amount of commas for affected rows up until the 16th line before it just started discounting the commas to indicate an empty field at the end of the table.
This would cause all sorts of errors with the program I had to upload the files to.
My only work around was a series of Regex based find and replaces in Notepad++, I could have perhaps scripted something automatic but I was on a very locked down machine at the time.
It was one of many weird MS Office bugs I had on a A3 sheet pinned to my cubicle wall.
This would cause all sorts of errors with the program I had to upload the files to.
My only work around was a series of Regex based find and replaces in Notepad++, I could have perhaps scripted something automatic but I was on a very locked down machine at the time.
It was one of many weird MS Office bugs I had on a A3 sheet pinned to my cubicle wall.