How about STRING FIELDA "," FIELDB "," FIELDC "," FIELDD DELIMITED BY 
SPACES INTO CSVFILE-REC

Michael Berkowitz 
Project Manager, CGS Application Solutions
707 Wilshire Blvd Suite 1900
Los Angeles, CA  90017-3509
T: 213 614-1308
F: 213 614-2028
[log in to unmask]




kellie Jones <[log in to unmask]> 
Sent by: HP-3000 Systems Discussion <[log in to unmask]>
03/07/2007 09:53 AM
Please respond to
kellie Jones <[log in to unmask]>


To
[log in to unmask]
cc

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 *


* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *