Hi Kellie :)
Have you got SuprTool from Robelle? Works like a charm... believe
',PRN' at the end of the output statement will do just what you want ...
otherwise it is still doable using COBOL but I would recommend BASIC/3000
as it does trimming and such easier (in my opinion... humble or not is for
the hearer to decide :) hehehe)
I used to use SuprTool all the time to prep for CSV files that I would
then download to PC's and network servers for loading into FoxPro, xBase,
dBase III+, Lotus 123, QuatroPro, Vulture (that is an old one!!!) and so on
...
Thanks,
Art "ahhh... the good old days ! hehehe" Bahrs
=======================================================
Art Bahrs, CISSP Information Security The Regence Group
(503) 225-4992 Cell 971-244-2459 FAX (503)
220-3806
"kellie Jones"
<kjones@BETTCH
ERLLC.COM> To
Sent by: [log in to unmask]
"HP-3000 cc
Systems
Discussion" Subject
<HP3000-L@RAVE [HP3000-L] Create a CSV file
N.UTC.EDU>
03/07/2007
09:53 AM
Please respond
to
"kellie Jones"
<kjones@BETTCH
ERLLC.COM>
|------------|
| [ ] Secure |
| E-mail |
|------------|
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 *
***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.***
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|