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

Hi stan,

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

cheers

rene

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      

hi stan,

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

cheers

rene

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.