Input File1
0BB2 2A11 Split,FriApr80625,1507_7RAID5
0BF6 2829 Synchronized,FriJan140653,1507_7RAID5
0BF6 282A Split,FriApr80625,1507_7RAID5
0C7C 199E Synchronized,FriJan140653,1507_7RAID5
0C7C 1BCC Split,FriApr80625,1507_7RAID5
0DCA 0A9B Synchronized,FriJan140653,1507_7RAID5
0DCA 0AA1 Split,FriApr80625,1507_7RAID5
144B 15A5 Synchronized,FriJan140653,1507_7RAID5
144B 15AD Split,FriApr80625,1507_7RAID5
0DDD 0AA2 Split,FriApr80625,1507_7RAID5
0DDD 15A6 Synchronized,FriJan140653,1507_7RAID5
0DDD 15AC Split,FriApr80625,1507_7RAID5
OUTPUT FILE 2
0BB2,0BB2(ERR)
0BF6,0BF6
0C7C,0C7C
0DCA,0DCA
144B,144B
0DDD,0DDD(ERR)
$1 in FILE1 should be pair of 2 , if its <2 or > 2 then $2 =$1(ERR) , else $2 = $1
OUTPUT FILE3
2A11,2A11(GC)
2829,2829(DR)
282A,282A(GC)
199E,199E(DR)
1BCC,1BCC(GC)
0A9B,0A9B(DR)
0AA1,0AA1(GC)
15A5,15A5(DR)
15AD,15AD(GC)
0AA2,0AA2(GC)
15A6,15A6(DR)
15AC,15AC(GC)
If the 3rd field in FILE1 has "date |sed 's/ //g' |awk -F"," '{print substr($1,1,3)substr($2,1,3)substr($2,6,1)}'" in it , $2 = $2(GC)
for example today's date is Friday, April 8, 2011 10:21:47 AM EDT , look for FriApr08 in the 3rd field
If 3rd field does not have the above date condition then $2 =$2(DR)
Thanks