More Voyager PT + AWK Goodness
One thing I’ve missed from the old TranPlan days was the reporting group. Â We’ve used that for many years to compare our transit loadings by major corridor. Â Unfortunately, that functionality was lost going to PT. Â I still need it, though, and enter awk.
The script below looks at the transit line file and outputs ONLY the line code, comma-separated. Â It uses a loop to check each field for ‘ NAME=’ and ‘USERN2’, which is where we now store our reporting group codes.
BEGIN{
FS=","
RS="LINE"
}
{
for (i=1;i<20;i++)
{
if($i~/ NAME=/)
{
printf "%s,",substr($i,8,length($i)-8)
}
if($i~/USERN2/)
{
printf "%s\n",substr($i,9)
}
}
}
The contents of the above need to be saved to a .awk file - I used trn.awk.
To call this, I use a Pilot script to call awk and pass the input and get the output.
*awk -f {CATALOG_DIR}/INPUTS/trn.awk {CATALOG_DIR}/INPUTS/OKIROUTES.LIN >{CATALOG_DIR}/OKIROUTES.CSV
The output of this is a simple two-column comma-separated-value file of the route ID and the reporting group.
