Possibility to filter/tailor CSV-utility-output ?

[Josef Thaler]

I'm looking for a possibility to filter and/or tailor the output of a csv-utility - by other criteria than available in the CSV List ... function - before transferring it to Excel.

 

For example, I'd like to extract alll SMF Element Activity data, but would like to omit all RETRIEVE and SIGNIN actions and actions for a particular Endevor-system. I also don't need all rows. (Of course such filtering/tailoring is possible in Excel, slimming down already on the mainfraime would ease the handling)  

 

Has anybody already a solution for that or similar and would like to share it?

 

Could the Table-tool  ENBPIU00 mentioned in https://communities.ca.com/thread/241693094 provide a solution?

 

Many thanks in advance!

[Karen Turner]

Hi Josef,

Have you looked at the OMIT option of SORT? Perform your CSV request with option NOCSV to an FB 4092 file, then feed it to SORT .  I havent tried OMIT with NO SORT criteria, but I have used it sorting on ENV, sys ,  etc:

//CSVIPT01 DD  *                                            

LIST TYPE * TO DDN LSTTYPE FROM ENV * SYS * STA * OPT NOCSV .

 

then SORT

 

//SORTIN DD  *

 

* SORT BY ENV (COL 14), SYSTEM (COL 22) THEN TYPE (COL 30)                                                                

    SORT FIELDS=(14,1,CH,A,22,8,CH,A,30,8,CH,A),                    

     SIZE=E3000000                                                                                                      

* SKIP TYPE PROCESS                                                                                                        

   OMIT COND=(30,8,CH,EQ,C'PROCESS ')                      

 

Then you import into EXCEL using Fixed delimiter of spaces

Karen

[Josef Thaler]

Hi Karen, many thanks for the hint: NOCSV is the clue.

Using sort is standard and available everywhere. The only little disadvantage is, that you have to count and check columns ...

Josef

btw:

If you don't want to sort the data, you may use SORT FIELDS=COPY   in //SYSIN

Slim down of the selected records and preparing them for use with excel is possible with the OUTREC FIELDS=.... option 

[Karen Turner]

Thanks for the sort fields=copy hint didn’t know that.  I have used OUTREC though love it

 

Karen

Karen Turner

Technical Support Sr. Specialist

Endevor Support

Software Code Mangement Team

860-902-3064 (IP phone)

508-399-5366 (home)

508-837-0606 (cell)

[Josef Thaler]

Hi Karen, maybe an alternative https://communities.ca.com/docs/DOC-231150837 (oops, added the link now, I'd forgotten) to count and check columns in NOCSV-data; but to count and check Endevor's CSV-column-titles ...

Kind regards, Josef