Using Gawk to get a SimpleTransit Loadings Table from Cube PT
One thing that I don’t like about Cube is the transit loadings report is stuck in the big program print report. Â To pull this out, the following code works pretty well:
gawk /'^REPORT LINES UserClass=Total'/,/'^Total '/ 63PTR00A.PRN >outputfile.txt
Where 63PTR00A.PRN is the print file. Note the spaces after ^Total. For whatever reason, using the karat (the ‘^’) isn’t working to find ‘Total’ as the first thing on the line. So, I added the spaces so it gets everything. Outputfile.txt is where this will go. It will just be the table.
NOTE: You need GNUWin32 installed to do this.
