csv - missing comma in last column

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

Hi,

Using Excel 2000, SP3

Situation:
Trying to do a SaveAs from XLS to CSV

The last column has some cells containing data, but the
majority of the cells are blank

Issue:
It looks like Excel is not adding the last comma for the
majority of the blank cells (it does it for a few of
them), when the file is saved to CSV

Is there a patch to fix this bug?

The closest KB article i could find matching this problem
was #259208.

thanks,
ap
 
You can fake the extra comma at the end with the Text Write Program by
specifying comma, CR, LF for the record delimiter. Try 44, 13, 10. 44 is
the code for a comma.

Regards from Virginia Beach,

EarlK
-------------------------------------------------------------
 
In light of the MS KB article that was in this thread, I think I would
use the fill handle to copy a space character all the way down, which
is probably what I did to recreated a Windows Address Book
..csv file for importing back to the WAB. Pretty dumb to require
a delimiter at the very end.



EarlK said:
You can fake the extra comma at the end with the Text Write Program by
specifying comma, CR, LF for the record delimiter. Try 44, 13, 10. 44 is
the code for a comma.

Regards from Virginia Beach,

EarlK
-------------------------------------------------------------
 
David,

Yeah, pretty silly to put an extra comma. I heard from a fellow from
Malaysia who needed a pipe-delimited file, with an extra pipe at the end of
each record. I told him it serves no purpose, but he said the program
reading the file needed it. So he used that technique I described and it
worked fine for him. All's well that ends well, I guess! :)

Regards from Virginia Beach,

EarlK
-------------------------------------------------------------

David McRitchie said:
In light of the MS KB article that was in this thread, I think I would
use the fill handle to copy a space character all the way down, which
is probably what I did to recreated a Windows Address Book
.csv file for importing back to the WAB. Pretty dumb to require
a delimiter at the very end.



"EarlK" <earlk livenet.net> wrote in message news:[email protected]...
 
Back
Top