|Welcome to the Monastery|
Re: Merge 2 files using key fieldby Limbic~Region (Chancellor)
|on Nov 05, 2013 at 13:15 UTC||Need Help??|
LanX indicated that the Monastery was a learning site. It is also a social site and a teaching site among other things. While I agree with LanX and Corion that you would have done yourself a favor by first searching to see if this same problem had already been asked, I can imagine that it is possible you did that and didn't understand or found that they didn't work for one reason or another. Unfortunately, you didn't indicate that so we have to assume you didn't bother searching (hopefully lesson learned).
As for your actual problem at hand, you need to state your constraints and your objectives. Below is a hypothetical list:
Had you done what I did above (remember, these are made up constraints/goals), it would have been easy to say "I looked at <some thread> but it won't work for me because of X".
If I take the simplest assumptions (file 1 can fit into memory, order doesn't matter, keys are unique, no lines in file 1 not in file 2) then the solution should be pretty obvious.
I hope this helps you understand how you can help yourself.
Cheers - L~R