LKBrwnDBA,
Apologies, but indirectly I did provide the data file's field seperator it is apart of the command line.
awk -F: '{ if($1 == 2014 && $2 == 9) if (index($15,"_")>0) print substr($15,length($15)-1); else print substr($15,1,2);print $2 $3 $1 $4 $5 $6 $8 $9 $10 $12 $13 $14 $15}'...