Unix awk command

kelbal

Hi,
Looking for some help on an awk command to merge two file together, would really appreciate seom guidance. I have 2 files like this....

file1.txt

1 a
2 b
3 c
4 d
5 e
6 f
7 g
8 h
9 i

file2.txt

1 j
3 k
5 l
7 m
9 n

I'd like to merge the two files together - listing all the values from both columns of file1 as well as the values from the 2nd column of file2 where the first column matches file1 - so you end up with this.....

output...

1 a j
2 b
3 c k
4 d
5 e l
6 f
7 g m
8 h
9 i n

Any idea on quick awk command to do this?

thanks in advance

Bruscar

I think reading into arrays and then using the split function might be the way to go.

Or you can just check out the link below, where someone has explained it all:

http://magvar.wordpress.com/2011/05/18/awking-it-how-to-load-a-file-into-an-array-in-awk/

kelbal

Thanks a million Bruscar - that sorted me out