Hi,

I have a file which contains names with counts for eg:

0622 0031 JOHN MAX 20080622003104. STAT 1.
0622 0031 BILL MAX 20080622003104. STAT 7.

and I have an exception file containing.

BILL

Can anyone help to write a script using this exception files to replace the STAT *(could be any number) to STAT 0 for the names that are in this list

the output should be and the format remains the same

0622 0031 JOHN MAX 20080622003104. STAT 0.

any comments or help appriciated.

I got a script which can do this, but it changes the format.
#!/usr/bin/ksh
nawk '
FNR==NR {ex[$1]; next}
{ $9 = ($1 in ex) ? "0." : $2; print }
' a2 a1 > a3

any help appriciated.
thanks