HP3000-L Archives

March 2007, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Create a CSV file
From:
kellie Jones <[log in to unmask]>
Reply To:
kellie Jones <[log in to unmask]>
Date:
Wed, 7 Mar 2007 12:53:27 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (19 lines) 
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 *

ATOM RSS1 RSS2