Search Results

Hi rangarasan/pravin27

Thanks for your post. I am getting following error on the code.
$ awk 'BEGIN{FS="|";}NR==FNR{a[$1$2]++;next}!a[$1$2]' file2 file1
awk: syntax error near line 1
awk:...

I am basically trying to identify the deleted rows from first file.
$ cat file1
HOME|ALICE STREET|3||NEW LISTING
HOME|NEWPORT STREET|1||NEW LISTING
HOME|KING STREET|5||NEW LISTING
HOME|WINSOME...

I have a very large system generated file containing around 500K rows size 100MB like following

HOME|ALICE STREET|3||NEW LISTING
HOME|NEWPORT STREET|1||NEW LISTING
HOME|KING...