View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Programmatic export to CSV

Not so random...

http://support.microsoft.com/default.aspx?scid=77295
Column Delimiters Missing in Spreadsheet Saved as Text

(It actually describes missing delimiter, but if some are "missing", maybe the
ones appearing are "extra".)

But a lot of programs (excel included) don't care about those extra columns.
Maybe you don't have to care, either???

Maybe you could write your own exporting program that would behave exactly the
way you want:

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(or maybe you could build your own formula and copy|paste that single column
into Notepad--and save from there.)

lucidr wrote:

Great; thank you.

Just have to figure out how to deal with Excel's randomly appended
trailing commas in the CSV now...

--
lucidr
------------------------------------------------------------------------
lucidr's Profile: http://www.excelforum.com/member.php...o&userid=36699
View this thread: http://www.excelforum.com/showthread...hreadid=564338


--

Dave Peterson