I don’t get to code much SQR in my current job, this is something new I learned recently.
Do you know that SQR supports writing CSV reports using its
print "Column 1" (1,1) print "Column 2" (,2) print "Column 3" (,3) print $line1a (+1,1) print $line1b (,2) print $line1c (,3) print $line2a (+1,1) print $line2b (,2) print $line2c (,3)
SQR takes care of the formatting if the value being printed contains embedded commas and quotes. To instruct SQR to print in CSV mode, the -EH_CSV should be added to the SQR command-line parameters. In Process Scheduler, it adds this parameter if you choose CSV as the output format.