Shell Programming and Scripting

Hello,

Please help me with this.

I have two files. file1.txt and file2.txt
File1 contains text as below
txt1 txt2
txt3 txt4
txt5 txt6
txt7 txt8

File2 contains text as below
$1 $2 $3 $4 $5 $6 $7 $8 $9
-----------------------------
txt1 txt2 - - - 0 2 8 -*-
txt0 txt7 - - - 1 4 8 -*-
txt3 txt4 - - - 9 7 6 -**
txta txtb - - - 5 0 8 -*-
txta txtb - - - 0 0 -1 -*-
txt5 txt6 - - - 8 3 9 **-
txt7 txt8 - - - 1 4 5 -*-

Is there a way I can print all the content in file2 matching with file1 as follows.
$1 $2 $8
txt1 txt2 8
txt3 txt4 6
txt5 txt6 9
txt7 txt8 5

Thanks so much.

Use nawk or /usr/xpg4/bin/awk on Solaris:

Code:

awk 'NR==FNR{a[$1$2];next} $1$2 in a {print$1, $2, $8}' file1 file2

Code:

$ sort file1 > file1.srt
$ sort file2 > file2.srt
$ join -1 1,2 -2 1,2 -o 2.1,2.2,2.8 file1.srt file2.srt
txt1 txt2 8
txt3 txt4 6
txt5 txt6 9
txt7 txt8 5

Code:

grep -f txt1 txt2 | awk '{print $1,$2,$8}'