Using Comma delimited files with powerhouse

[georgia miller]

____________________________________________________________________
>To: 'PH User Group'
>From: Clark, Andrew on Wed, Mar 3, 1999 7:47 AM
>Subject: Using Comma delimited files with powerhouse

>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)


What I have to do on the HP3000 is run the variable length file through a program  called TFIXED that puts the tab delimited fields into columns based on the length of fields defined in the first record of the file.  Then I have the newly created file with fields put into columns defined in my PDL dictionary.

My boss wrote the TFIXED program - I'm not sure what language, but not Powerhouse.  I don't think that Powerhouse can handle variable length files and fields.

Georgia Miller, Systems Analyst
Great Falls Public Schools
Email: georgia_miller@gfps.k12.mt.us
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.