Specifying a length of 0 should take care of trailing spaces.
Original Message:
Sent: Wed June 12, 2024 11:09 AM
From: Stan van OERS
Subject: CSV report without blanks and " characters
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:
Sent: Wed June 12, 2024 10:21 AM
From: Stan van OERS
Subject: CSV report without blanks and " characters
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
------------------------------