Shell Programming and Scripting

you didn't mention the FieldSeparator in your original post - it was assumed to be 'space||tab'.

Code:

BEGIN {
   FS=OFS=","
}
{ idx = $1 SUBSEP $2 SUBSEP $5 SUBSEP $6 }
NR==FNR { fnew[ idx ] = $0; next }
{
   if ( !(idx in fnew) )
      $0 = $0 ORS fold[idx]
}
1

I did put that in:

BEGIN{FS=OFS=","}
{ idx = $1 SUBSEP $2 SUBSEP $5 SUBSEP $6 }
NR==FNR { fnew[ idx ] = $0; next }
{
if ( !(idx in fnew) )
$0 = $0 ORS fold[idx]
}
1


Not sure ??? I don't know why but I am getting both lines of file2.
Did this happen with you?
It sure looks like it should work.
very odd.

i'm beat

I've got a way:

----------

#!/bin/ksh

file1="file1"
file2="file2"

nawk -F, 'BEGIN {
while ((getline < "'$file1'") > 0) {
file2_ar[$1] = $1;
file2_ar[$2] = $2;
file2_ar[$5] = $5;
file2_ar[$6] = $6;
}
OFS=","; }

{
if (file2_ar[$1] && file2_ar[$2] && file2_ar[$5] && file2_ar[$6]);
else
print $0;
}
END{}' $file2 > OUT


-----------

The other way wouldn't seem to work for me, it looked alot cleaner, but hey. Temp Man lives another day!.......thanks 4 help

Code:

nawk -F, '{
   if (NR == FNR)
      print ar[$1$2$5$6] $0
   else
      if (!($1$2$5$6 in ar))
         print
}' file1 file2