space delimited output from excel
Posted by Franz on February 13, 2001 3:42 AM
Please help,
I need to create a flat file output from excel, the *.prn file format works fine except that after 260 characters it does a line wrap!!!!
How can I get around this?
Posted by Mark W. on February 13, 2001 7:08 AM
Franz, have you considered saving in tab
delimited format and then stripping them off with
and editor? If you need a fixed format record
length you can change the worksheet's font to
a nonporportional font such as Courier and apply
cell formats to pad each cell with spaces. Cells
containing text should be formatted as "@* " and
cells containing numeric cells should be formatted
in a similiar fashion, but using their specific
numeric format (e.g., "* 0.00").
Note: the formats
listed above don't include the quotes. I included
them so you could see where a space was needed.
