Just ran another test from scratch. Did the same thing. It puts
the , in the first 15 rows then stops.
If I put something in the bottom right hand column, it'll put commas
starting after the preceding row multiple of 16.
No big deal now that I know what it is doing.
...
key94,value94
That is not the problem. The problem is that you have a row that does
not contain enough columns.
Try open with excel, then export it again.
On Dec 7, 1:10 pm, pftpft john_kas...@mailworks.org wrote:
Using the 'database administration', I am trying to import an Excel
generated CSV file (with
Weird, looks like an Excel'97 bug. It stopped putting the closing
comma after the second column after the 16th row (then starts back up
again after the 32nd). Here's a test CSV:
key,value,description
key1,value1,
key2,value2,
key3,value3,
key4,value4,
key5,value5,
key6,value6,
key7,value7,
Just curious but are you sure that column 3 on rows 1-15 and 32 onward
are empty. When just tested to make a CSV file with Excel 2010 and if
column 3 is empty Excel doesn´t put any closing characters on column 2.
Kenneth
Weird, looks like an Excel'97 bug. It stopped putting the closing
4 matches
Mail list logo