Hi,
I currently have two files one that looks like this (File1):
Code:
2R 123
2R 1678
3R 12
3R 1231
.. ..
and the other (File2) looks like this:
Code:
2R 10 34 12 21 23
2R 12 88 82 11 44
2R 44 10 21 31 44
2R 123 56 11 23 44
2R 555 13 11 33 55
2R 1678 12 22 77 33
3R 12 33 18 92 11
3R 1231 44 22 11 22
3R 2000 11 99 22 13
....................
I need too extract all of the rows from File2 where the first two columns have entries matching those in File1.
So, based on the example I have here, my output would look like:
Code:
2R 123 56 11 23 44
2R 1678 12 22 77 33
3R 12 33 18 92 11
3R 1231 44 22 11 22
I was able to find ways of doing similar if say File1 only had one column and I was only extracting rows from File2 based on that single column. But I haven't had any luck translating that to when I need to extract rows based on 2 columns.