RE: spool file to excel

www.nextract.com

(one of our products, in use by as400 users for at least ten years.)

Brad Jensen

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
> Sent: Tuesday, November 25, 2003 9:41 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: spool file to excel
> 
> 
> Simple, versus long term.
> 
> Maybe you could copy the program.  Convert the output from spool to 
> database.  And then download that instead.  There are even methods of 
> converting the database to a stream file in the IFS.  Then 
> Excel could get 
> that instead.  Some programming but might pay off.
> 
> Another option is to purchase a tool like Monarch to do some 
> of this for 
> you.  Supposed to do a clean job of extracting data from spool files. 
> Haven't used it.
> 
> Rob Berendt
> -- 
> "They that can give up essential liberty to obtain a little temporary 
> safety deserve neither liberty nor safety." 
> Benjamin Franklin 
> 
> 
> 
> 
> pedro.reis@xxxxxxxxx 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 11/25/2003 10:03 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> midrange-l@xxxxxxxxxxxx
> cc
> 
> Fax to
> 
> Subject
> spool file  to excel
> 
> 
> 
> 
> 
> 
> Hello,
> 
> I've got a spool file that that i want to convert to excel , 
> so i copy it from ops nav to .txt and then with Excel i cut 
> the columns values. Is 
> there
> a simple way to do that ?
> 
> 
> 
> 
> 
> 
> Cumprimentos/Salutations/Best Regards,
> Pedro Reis
> Information Systems
> VALEO - Electronics & Connective Systems
> Peugeot Citroën Group Division
> Cablinal Portuguesa Zona Industrial II 4900-232 Neiva - Portugal
> --------------------------------------------------------------
> ---------------------------------------
> 
> e-mail: pedro.reis@xxxxxxxxx
> Phone: 351-258 350 725
> Fax: 351-258 351 060
> 
> "This e-mail message is intended only for the use of the 
> intended recipient(s). The information contained therein may 
> be confidential or privileged, and its disclosure or 
> reproduction is strictly prohibited. If you are not the 
> intended recipient, please return it immediately to its 
> sender at the above address and destroy it."
> 
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list To post a message email: 
> MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>