Hi,

I have 2 text files n1 and n2.

cat n1 :
--------
1234567890
4444444444

cat n2 :
---------
1234567890
4444444444
7777777777
8888888888

they are some sample records. File n1 contains some lookup records, whereas file n2 contains some transaction records. I need to get the transaction records from file n2 , which are not there in lookup file n1. For eg., from the above files I should get :

7777777777
8888888888

Is there any way using AWK arrays? grep will run for hours since the records are millions.

Thanks in advance

kanu_kanu

This is based on your example:

awk 'FILENAME=="file1" {arr[$0]++}
       FILENAME=="file2"{ if($0 in arr) {continue}
                         else {print $0}}'  file1 file2

Thanks... working