Shell Programming and Scripting

Hi All,

Here is my question.

I have two files, file1.txt and file2.txt. I need the line number (index number) of file2.txt where the words in file1.txt appear. But they have to be in the same order as file1.txt. In example,

file1.txt

Code:

Z
K
A
...
T

file2.txt

Code:

W
A 
Q
R
Z 
J
K 
T 
...
H
L

output.txt

Code:

5:Z
7:K
2:A
...
8:T

I am using

grep -n -w -f file1.txt file2.txt > output.txt

However, it is not in the order that i want.

Thanks in advance,

Moderator's Comments:

Please use code tags when posting data and code samples!

Code:

nawk 'FNR==NR{f1[$1];next} $1 in f1 {print FNR, $1}' OFS=: file1 file2

It says

nawk: Command not found

try either awk or gawk.

Yes, i did but the output file was empty.

intersting... given your sample files:

Code:

$ awk 'FNR==NR{f1[$1];next} $1 in f1 {print FNR, $1}' OFS=: s1.txt s2.txt
2:A
5:Z
7:K
8:T

check your input file formats against what you've posted. Any hidden chars?

sorry, you need a file1 order... try:

Code:

$ awk 'FNR==NR{f2[$1]=FNR;next} $1 in f2 {print f2[$1],$1}' OFS=: s2.txt s1.txt
5:Z
7:K
2:A
8:T