Reading/loading a 'text' file as a subfile, or into a flatfile - is there an easy way ?

[Michel Adam]

Ken has graciously provided a little utility that does just what I need
(thanks Ken!). It pads the input file to a fixed length output file.
Problem solved.

Michel 


-----Original Message-----
From: powerh-l-bounces+michel_adam=gov.nt.ca at lists.sowder.com
[mailto:powerh-l-bounces+michel_adam=gov.nt.ca at lists.sowder.com] On
Behalf Of Richard Witkopp
Sent: Friday, 12 October, 2012 14:06
To: powerh-l at lists.sowder.com
Subject: RE: Reading/loading a 'text' file as a subfile, or into a
flatfile - is there an easy way ?

On VMS I just write a quick (no pun intended) ad hoc program to create a
subfile that matches the format of the file you're trying to read. Then
I run an analyze on the subfile .sf to get an .fdl. Then I run CONVERT
on the text file using the .fdl, rename it to be the same as the
subfile, and you're done.

I imagine similar utilities are available on other platforms.

-----Original Message-----
From: powerh-l-bounces+rwitkopp=phxa.com at lists.sowder.com
[mailto:powerh-l-bounces+rwitkopp=phxa.com at lists.sowder.com] On Behalf
Of Michel Adam
Sent: Friday, October 12, 2012 12:34 PM
To: powerh-l at lists.sowder.com
Subject: Reading/loading a 'text' file as a subfile, or into a flat file
- is there an easy way ?

This has probably been answered any number of times before, but:

With PH on Wintel, I'd like to process a '.txt' file with QTP, or
convert it / load it into a flat file with the least amount of fuss
possible.

Are there any tools/tricks that will let PH deal with a variable record
length (byte stream) file as if it was a fixed length flat file ?

Thanks 

Michel Adam


--