Re: Any way to pull data from a spool file

>  > I wanted to connect to an AS/400 spool file and take the text and place it
>>  into certain fields. Is this possible. I have had consultants say that there
>>  programs can in fact connect to spool files and puts the data into fields
>>  that can be pulled out by a visual basic program. I just can see how someone
>>  could idenitfy the text to know where to go.
>>  Any help is much appreciated!!
>>  Jon
>>
>
>One product that I've used is called Monarch.  It works extremely well
>and can differentiate between heading, detail and (sub)total lines on
>a report.  It can output into any number of different formats.
>
>Barry


If this is only a one-time task, you can extract the spool file to a
data base file, download it to a PC, then import the text file into
Excell.  Excell has a text import function that works similar to
Monarch.  Monarch has the advantage that you can store the extract
parameters for re-use.

--Paul E Musselman
PaulMmn@ix.netcom.nospam.com