Dear All,

Is it possible to compare 2 files line to line using column values?

for example I have file1:

1;givi;01012000;wer
2;sss;02012000;rrr
3;ccc;03012000;ttt

file 2:

0;uuu;01012000;lll
1;givi;01012000;wer
2;sss;02012000;rrr
3;ccc;03012000;ttt
5;givi;01012000;hhh

I want to get only lines from file2 where combination of 2nd and 3rd columns do not exist in file 1. it means that one line from file2 shuld compare to all lines in file1?????

Thanks in advance.

Givi

Try...

Thank you very much.
Exactly I wanted.

Hello all awk masters.

i have query but i need add some change and i don't know how.
my current awk program is :

nawk -F"~" -f m.awk file1

m.awk:
BEGIN {
while(getline<"file2")
arr[$1,$7]=1
}
arr[$1,$7]!=1 {print }

additionaly i need to change $2 from file1 to $2 from file2
so display is line from file1 with $2 from file2

Thanks in advance.
Peter

Hello Ygor,

Would you please explain what that does

a[$2,$3]=1};a[$2,$3]!=1' from your previous post. I am trying to digest this code.