IBM Security Z Security

 View Only

  • 1.  CSV report without blanks and " characters

    Posted 23 days ago

    Hello,

    If I create a CSV report, there are sometimes " signs round the entry and sometimes not.

    Sample:

    AC,"AUTBASE ","AOC/MVS AUTOTASK USE",MAOC,"YES       ",15May2024,"OAR ID= AAB.SYS.022262                                                                                                
    AC,AUTBAT10,"AOC/MVS AUTOTASK USE",MAOC,"YES       ","11Apr2020","OAR ID= AAB.SYS.022262      

    So, AUTBASE has " round the field and AUTBAT10 not.

    15may2024 has no " character round the field, but 11Apr2020 has.

    The last field has no closing " character.

    So, now it is difficult to automatic load this in a  database or excel,  becuause the fields are not consequent filled.

    Is it possible to get a report with only , separated so like:

    AC,AUTBASE,AOC/MVS AUTOTASK USE,MAOC,YES,15May2024,OAR ID= AAB.SYS.022262                                                                                                
    AC,AUTBAT10,AOC/MVS AUTOTASK USE,MAOC,YES,11Apr2020,OAR ID= AAB.SYS.022262      

    With kind regards

    Stan van Oers

      



    ------------------------------
    Stan van OERS
    ------------------------------


  • 2.  RE: CSV report without blanks and " characters

    Posted 23 days ago

    Hi stan,

    how did you create the output ? Your own CARLa query or somewhere in the zSecure UI ?

    cheers

    rene



    ------------------------------
    RENE van TIL
    ------------------------------

    Original Message


  • 3.  RE: CSV report without blanks and " characters

    Posted 23 days ago

    Ha Rene,

     

    Alles goed?

     

    Ik heb mijn eigen CARLA gebakken

     

    n required n=baseud1 outlim=0 segment=base                                    

      s c=user segment=base  OWNER<>HUMAN                                         

      sortlist segment                                                            

    newlist type=racf retain nopage header=csv proflist=baseud1,                  

     name=npaoar,                                                                 

     title="NPA's with OAR-id"                                                    

     OPTION  smtpnjenode=PR smtpclass=B smtpwriter=TCPSMTP,                       

      outputformat=attach encoding=utf-8,                                         

      mt=`xxxxx@kyndryl.com,                                              

          yyyyy@nl.abnamro.com`,                                            

      from=`xxxxx@nl.abnamro.com`,               

      cc=`xxxxx@kyndryl.com`                                              

     s c=user s=csdata (custom_data(cstype=char cskey=OAR* csvalue>` `) or        

     custom_data(cstype¬=char cskey=OAR*))                                        

     sortlist  complex key(8,"User") key:pgmrname, key:owner,                     

         key:protected(10,"Protected"),                                           

         key:ljdate(9,"LastUse"),                                                 

         custom_data("Custom Data",1141,header)                                   

                                                                                   

     

     

     

    With Kind regards,

     

    Stan van Oers

     

    Kyndryl Mainframe Technical Specialist for ABN AMRO

    Mobile: +31(0)6-51344171

    E-mail: stan.van.oers@kyndryl.com

     

    www.kyndryl.com

    cid172802*<a href=image001.jpg@01D9A2DF.0A7D97B0">

     

    Free day on Monday in the odd weeks.

     

     




    Original Message


  • 4.  RE: CSV report without blanks and " characters

    Posted 22 days ago

    Rene,

    I want a report with only , - separated and no leading or ending  spaces in field.

    So

    AC,AUTBASE,AOC/MVS AUTOTASK USE,MAOC,YES,15May2024,OAR ID= AAB.SYS.022262           

    instead off

    AC,"AUTBASE ","AOC/MVS AUTOTASK USE",MAOC,"YES       ",15May2024,"OAR ID= AAB.SYS.022262      



    ------------------------------
    Stan van OERS
    ------------------------------

    Original Message


  • 5.  RE: CSV report without blanks and " characters

    Posted 22 days ago

    hi stan,

    Specifying a length of 0 should take care of trailing spaces.

    cheers

    rene



    ------------------------------
    RENE van TIL
    ------------------------------

    Original Message


  • 6.  RE: CSV report without blanks and " characters

    IBM Champion
    Posted 22 days ago

    Hi Stan

    Consider using TSV instead of CSV.  With TAB as a separator, there is much less need for quotes in the string.  Excel and OpenCalc have import options to specify TAB as the separator.

    Also, consider using numerical date formats such as $DATE instead of the default.  I have seen Excel do strange things when customers have Swedish or Dutch set as their local language, like Mar, May and Oct would not be recognized.

    And finally, use the "with title" variants, CSVT and TSVT, so your file gets a line with field names.



    ------------------------------
    Rob van Hoboken
    ------------------------------

    Original Message