Shell Programming and Scripting

Hi all,

I would like to compare a column in one file to a column in another file and when there is a match it prints the first column and the corresponding second column. Example

File1
ABA
ABC
ABE
ABF

File 2
ABA 123
ABB 124
ABD 125
ABC 126

So what I would like printed to a file is
ABA 123
ABC 126

The only thing is that in file 1 there are 8,000 columns while in file 2 there are 140,000 columns to search for. I have tried awk and grep-f but it doesn't work or is very slow?

Any quick solutions?

Thanks

Here is one solution:

Code:

join file1 file2

Note that both files must be sorted.

I would prefer not to sort them because I want to keep them in the order in which they are because it corresponds to a large excel file and join does not work for me

Code:

awk 'NR==FNR{a[$0]=1}NR>FNR&&a[$1]' file1 file2

awk 'NR==FNR{a[$0]=1}NR>FNR&&a[$1]' file1 file2
does not work

how about this?

Code:

awk 'NR==FNR{a[$1]=1}NR>FNR&&a[$1]' file1 file2

Code:

grep -f File1 File2