Using Comma delimited files with powerhouse

[Kim Williams]

I wrote a command file that does a pretty good job of converting comma delimited
files created in Excel to portable subfiles that Quiz can read.  I did this on 
the HP 3000 but maybe you can do something like it on your system.  You can find
it at http://www.denkor.com/hp3000/command_files/  Click on Powerhouse XEQs and 
mine is delim.xeq.  You could also email me privately and I will send it (it's 
kind of long).

I have since made some modifications so the file you are converting could be 
bigger (I was filling up the variable tables).  I guess I will get my act 
together and send the new version to the website.

I used this for some large file transfers and it was very helpful.  The main 
problem was filling up the variable table so I ended up having to break the very
large files down into smaller pieces and converting them seperately.

Kim Williams

______________________________ Reply Separator _________________________________
Subject: Using Comma delimited files with powerhouse 
Author:  "Clark  Andrew" <andrew.clark@acco-uk.co.uk>  at internet
Date:    3/3/99 2:36 PM


Afternoon all (depending where you are of course)

We work on VMS with powerhouse 7.10.e6 & RMS Files

We are getting requests to send out files of info in comma delimited 
forms (which we can do very simply) but we are also getting more 
information in files sent to us in comma delimited forms.  To be able to 
process this info in powerhouse we are having to take this info into 
something like MS Access or Excel which can handle the format, and 
exporting from this fixed width files, so that we can process it.

Does anyone have any simple way of handling comma delimited files with 
powerhouse, without having to perform this intermediate step?

Regards...

Andrew Clark
ACCO UK LTD
(IT Development)

Tel:        01296 397444 (Ext:4075)
Fax:  01296 311019
Email:        andrew.clark@acco-uk.co.uk

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu 
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu 
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.