Donna brings up a good point, BYTE-STREAM files, and therefore, what
about writing XML instead of CSV, into a byte-stream file, samba share?
Not only does Excel understand XML, but I think a few (thousand) more
programs do as well.
>>> Donna Hofmeister <[log in to unmask]> 3/7/2007 2:07 pm >>>
cobol will happily write to a bytestream file. no magic
required....just a file equation.
the other suggested solutions will work...just write out to a
bytestream file.
if you're are of a perl-ish inclination....there is a 'spreadsheet'
module that will read and write real .xls files...on mpe! (i've played
with the read portion of this module. it works file and i would expect
the write portion to work as well.)
there's no real need to ship (email/ftp/file transfer) your output
file. fire up samba and create a share. have your users map to this
directory and let them click-ity-click. - d
-----
Donna Hofmeister, HP-CSA Sr. System Programmer
dgarverick -at- longs -dot- com
925-210-6631 Longs Drug Stores
>>>MY opinions, not Longs Drug Stores'<<<
----- Original Message ----
From: kellie Jones <[log in to unmask]>
To: [log in to unmask]
Sent: Wednesday, March 7, 2007 9:53:27 AM
Subject: [HP3000-L] Create a CSV file
I've read the archives - and the only info I can find on CSV files is
converting
to fixed from a csv file.
I was wondering if there was a way to create a *real* csv file on the
3000.
I don't have many resources - I can create a csv file with COBOL or
with
QUIZ. What they really are is a fixed length file with commas in
between the
fields. Problem is, if you open the file up in excel - there are extra
spaces, and
it doesn't handle it correctly (you can see the data fine - but if you
need to
load it into a database or do a lookup - it includes the trailing
spaces). I'd
have to do a trim in excel and re-save the file to get rid of the
spaces.
Is there a way to do this in COBOL or even just from the OS?
tia
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
____________________________________________________________________________________
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|