Spool file wrong order in excel

[tintin]

Hi all.

I have a spool file -->PF by CPYSPLF then down load to EXcel but itn't very good order.

How to load to excel good order, or create a program to do it.

Thanks for your all support

TinTin

[Andrew K]

Re: Spool file wrong order in excel

Quick way is to just use a query and chop the one big field that you get from the CPYSPLF up into 'real' fields and then use those as 'sort fields'. Output to another file and download that into Excel?

[jamief]

Re: Spool file wrong order in excel

at the same time you write the spooled file write a csv file. then use this for the excel process.

jamie

[tintin]

Re: Spool file wrong order in excel

Hi

I want to get (PF file from Spoolfile )one by one record to cells appointed in worksheet in excel.
Can you give me some book reference to coding or your technical of this problem.
I can not read data after down to excel.
How to ""chop the one big field that you get from the CPYSPLF up into 'real' fields ""
Thanks a lot.
Tintin

[jamief]

Re: Spool file wrong order in excel

please download this tool and take a look at what it does.

http://www.code400.com/Iseries2CSV.php

this will help you understand that you must place "," between each field to
make them show in different cells.

jamie

[tintin]

Re: réspool file base on another spool file

Hi, Jaimf
Help me please.

I have a spool file layout not good,
I want to change but i can not touch PF directly to code printer file
Fix base on spool file only, how to do that?

Thanks in advance.
Tintin

[Mercury]

Re: Spool file wrong order in excel

Tintin,
Je peux t'aider en français si tu veux.
(I can help you in french if you like.)

[tintin]

Re: Spool file wrong order in excel

Hi, Mercury
why you don't help me by English.
I think my french not enough to understand.
English please.
you welcome.
Tintin

[Mercury]

Re: Spool file wrong order in excel

why you don't help me by English

because Tintin is a Belgian comics magazine named after the character Tintin and very famous over there in western Europe. I thought you were french speaking by that name.

So I let Jamie get along with that thread

[tintin]

Re: Spool file wrong order in excel

Oh, my god!
No kidding
I think anyone can help me if they have know how to do.
Thank you.

[jamief]

Re: Spool file wrong order in excel

(thanks for the pass Mercury I owe you one )

is this spooled file in O'specs like this

ORET_GOODS1E            FORM           1 01       
O                       GCCDES              30    
O                       CUST_COPY           50    
o                       dacnum              52    
o                       ShrName             82    
                                                  
O          E            FORM           1          
O                       GCADD1              30    
                                                  
O          E            FORM           1          
O                       COMP_LINE3          32    
                                                  
O          E            FORM           2          
O                       COMP_LINE4          32    
O                       RG#                 74 

or printer file like this

.AAN01N02N03T.Name++++++RLen++TDpBLinPosFunctions++++++++++++++++++++++++
 A          R SLSHEADER                                                  
--------- 3 data records excluded ---------------------------------------
 A                                      SPACEA(001)                      
 A            P1EMAIL1      78A  O     2                                 
 A                                      SPACEB(001)                      
 A            P1EMAIL2      78A  O     2                                 
 A                                      SPACEB(001)                      
 A            P1EMAIL3      78A  O     2                                 
 A                                      SPACEB(001)                      
 A                                     2                                 
 A                                      DATE(*SYS)                       
 A                                      EDTWRD('0  /  /  ')              
 A                                      SKIPB(005)                       
 A                                   +16                                 
 A                                      'Returned Goods Reason Print'    
 A                                    70                                 
 A                                      'PAGE:'                          
 A                                    76                                 
 A                                      PAGNBR                           
 A                                      EDTCDE(Z) 

that should get us started

jamie

[tintin]

Re: Spool file wrong order in excel

HI, Jaimf

I think we convert spool file to PF then chop to real filed to new PF

and read all records of new PF with filter then write to printer file--> new report

But I do not how to chop to real file or filter data from new PF.

Jaimf, you can not ?may my thread is a stupid idea?
Thanks for your your post.
tintin

[jtemple]

Re: Spool file wrong order in excel

Tintin,

May I suggest taking a look at Monarch: http://www.datawatch.com.

This tool will take a "report" file and convert it to Excel. You already have the first step. You need to copy the spooled file to a PF. Then you download the PF to your PC and run Monarch against it. It's been a while but I believe Monarch will ask you where columns begin and end and you can designate report headings/footings that you do not want in your extracted data.

[tintin]

Re: Spool file wrong order in excel

HI,
First, I thank for your so much
then i take a look now.
Regards
Tintin