RE: Download Spoolfiles

["Stone, Brad V (TC OASIS)" <bvstone@xxxxxxxxxxxxxx>]

Chris,

SPLTOOL will do this.  You can download a spooled file in a .txt format.
SPLTOOL will even let you remove standard headings from your spooled file.
(ie if the headings are on lines 1-5 of every page, removing them is
simple).

Then you open excel and open the .txt file you downloaded.  Excel will
autoformat by seperating columns of the spooled file.  Works pretty slick.
I've used it a lot.

Check out http://www.bvstools.com/spltool.html

Bradley V. Stone
BVS/Tools
http://www.bvstools.com





> -----Original Message-----
> From: Chris [mailto:christophe.wenk@kuehne-nagel.com]
> Sent: Friday, November 05, 1999 1:47 AM
> To: MIDRANGE-L@midrange.com
> Subject: Download Spoolfiles
> 
> 
> How can I download spoolfiles into Excel on a very easy way. 
> (Comma delim.)
> I have an AS/400 and a PC. (Both connected on Ethernet)
> I know that I could use cpysplf and upload the file to the pc 
> with FTP. But
> how could I
> make the whole process simpler.
> 
> Thanks a lot
> Chris
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---