fixed width column export

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I want to export certain data as a fixed-width column, ascii text file.
I've got the info in excel, have formatted my columns appropriately. When I
choose "formatted text (space delimited)" it works, BUT with the following
limitation:

All my fields EXCEPT THE LAST FIELD are exported correctly on the same line
(no CRLF). BUT the last field in each record is put onto its' own line at
the bottom of the file. I would guess (and that's all it is, really, a
guess) given the file suffix (*.prn) that the lines are being truncated to
fit a given page size on a given printer (probably my default). Is there
ANY WAY to tell excel to just export as text, not as a printer destination
file? I guess I'll try to fool it by setting up a printer with a gargantuan
page size.

Thanks

Dave
 
Dave said:
I want to export certain data as a fixed-width column, ascii text file.
I've got the info in excel, have formatted my columns appropriately. When I
choose "formatted text (space delimited)" it works, BUT with the following
limitation:

All my fields EXCEPT THE LAST FIELD are exported correctly on the same line
(no CRLF). BUT the last field in each record is put onto its' own line at
the bottom of the file. I would guess (and that's all it is, really, a
guess) given the file suffix (*.prn) that the lines are being truncated to
fit a given page size on a given printer (probably my default). Is there
ANY WAY to tell excel to just export as text, not as a printer destination
file? I guess I'll try to fool it by setting up a printer with a gargantuan
page size.
Click to expand...

Just an addendum: I've set up my print drive to print everything on one
page width and it prints out just fine (other than being so tiny it's
illegible). Did not correct the problem in my .prn file though...
 
Back
Top