Hello all,

Can anyone help me with this.
There are two files and I have to match the second file records with that of first and if matched, print the output in two fies, one containing the matched records and other containing the rest.

Here is the example.
As can be seen 111 and yu8 matches with the first reord in file 1, so the whole row should be printed.

Output should be
Can anyone help me with this. Thanks.

By looking at your 2 examples, why don't you;
[1] loop thru the contents of the 2nd file
[2] compare every individual line of the 2nd file with all the lines in the first
[3] print matched lines to file3
[4] After looping thru all the entries in file2, do a diff between file1 and file_matched
[5] parse the o/p of [4] to file4

Disclaimer: I couldn't script if my life depended on it, so can't really help you with that.

Thanks Frozentin but the issue here is that one of the file (file1 in this case ) has huge no of records and looping and comparing is taking a lot of time.

Is there any alternative way to do this with good performance.

Please advise.

This suggestion depends on how big your second file is.

But, you could try to put all the entries of the 2nd file into a grep list and then loop thru the 1st file only once. This way you avoid multiple loops that I suggested in my last post.

One more way would be to attack the i/p file in chunks of say 1000 lines, and append o/p to file3/4.

Can you please post the script for this as I am not getting to compare by using loop

Thnaks

mah