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:
From:
Tracy Pierce <[log in to unmask]>
Reply To:
Tracy Pierce <[log in to unmask]>
Date:
Wed, 7 Mar 2007 10:22:55 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (41 lines)
Suprtool can do it using any file for which it knows your field
locations & types. 

> -----Original Message-----
> From: HP-3000 Systems Discussion 
> [mailto:[log in to unmask]] On Behalf Of kellie Jones
> Sent: Wednesday, March 07, 2007 9:53 AM
> To: [log in to unmask]
> Subject: 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 *

ATOM RSS1 RSS2