Shell Programming and Scripting

02.12.2011 16.28.29:200 PDU  IN CI:424 TRID:200 ID:N/A EID:N/A EX:N/A PDU:0000001f0000000100000000000000c874746f700074746f70000034010100
02.12.2011 16.28.29:228 PDU  OU CI:424 TRID:200 ID:N/A EID:N/A EX:ACK PDU:000000168000000100000000000000c8000210000134

#!/bin/sh
#get all combination of TRID, CID
nawk -v v=200202 '{if(match($5,v))print $5 " "$6}' $LOG | uniq > $OUTPUT
#find PDU IN,OU that match above combination TRID,CID
while read line 
do
grep -w "`echo $line`" $LOG | nawk -v v="$line" '{
if($4=="IN") printf"%s in: %s ",v,$2;
if($4=="OU") printf"out: %s\n",$2; 
}'
done < $OUTPUT

CI:200202 TRID:273111253 in: 20.30.19:760 out: 20.30.19:775
CI:200202 TRID:273111269 in: 20.30.20:400 out: 20.30.20:402
CI:200202 TRID:273111278 in: 20.30.20:400 out: 20.30.20:415
CI:200202 TRID:273111269 in: 20.30.20:400 out: 20.30.20:402
CI:200202 TRID:273111278 in: 20.30.20:400 out: 20.30.20:415

nawk -v v=200202 -F '[: ]*' '
  $7==v&&$5=="IN" { I[$9]=$2":"$3}
  $7==v&&$5=="OU" { O[$9]=$2":"$3}
  END {for(t in O) print "CI:"v " TRID:"t " in: "I[t] " out: "O[t] }' infile

-F '[: ]*' '

':' single colon
' ' single space
'    ' multiple spaces
'::::' multiple colons
'   :: :   :  '  multiple spaces and colons in random places