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.