Using Comma delimited files with powerhouse

[Rohde Dirk (Van)]

If you decide to use DCL to write this routine, check out the f$element
lexical for selecting your items in the list.  If you wish to use
PowerHouse, you'll need to define the incoming record structure as one big
field and use the INDEX function to break up the items.  This could get
messy, depending on the number of fields that are incoming.  It may be
necessary to convert the file into a fixed format first if it is variable
(using convert).

Dirk Rohde
VantagePoint Group

-----Original Message-----
From: Kim Williams [mailto:kim.williams@ashtech.COM]
Sent: Wednesday, March 03, 1999 10:16 AM
To: powerh-l@lists.swau.edu; andrew.clark@acco-uk.co.uk
Subject: Re: Using Comma delimited files with powerhouse 



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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.