Monks,
I am in need of your wisdom. I have 2 files, that look something like this:
File 1
aa-aa1-aa
aa-aa2-aa
aa-aa2-ab
aa-aa3-bc
File 2
V1111:something
V1111:something
V2222:something
V1111:something
A third file will look like this:
aa-aa1-aa
aa-aa2-ab
I need to search file 1 for matches to file 3, and then output the corresponding line from file 2. So with the example above, the output should show
V1111:something
V2222:something
Essentially, if the first match in file 1 is on line 3, I need line 3 from file 2. I have no idea on how to match those values up to get the output I need. Thanks as always for any ideas.