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 command? In the column number, specify the column number as it will be displayed in Excel. For example, a 3-column sheet, the SQR code looks like this:


   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.