UNIX for Dummies Questions & Answers

I am a new unix user & I wanted to work with unix as it is very good in text manipulations. I need a little help. I will be grateful if someone can help me out.

I need help in grepping a pattern of numbers from one file to another file. Specific details are as follows:

File one contains only one column of numbers like

897887738753
881388745527
237818494899
331388745702
451388746000
911388746146
891388746156

file 2 contains three column of numbers 1st column is just the hash mark then another set of numbers & then column 3 (the numbers of my interest).

## 234451388746000 447887738753
## 234159018106564 447818494899
## 234159055332992 897887738753
## 234159043784408 881388745527
## 234159026266547 237818494899
## 234154821274370 331388745702
## 234159053081262 451388746000
## 234159020233321 911388746146
## 234159014081879 891388746156

I want to grep numbers in File 1 from 3rd column of file 2 and as a result I should get out put as the whole line in file 2 which has the matching number in column 3 of file 1

I am trying: grep -f file1 file2 > file3

but the problem with it is that if it finds a similar match even in column 2 it prints it. Like in above case output will be

## 234159055332992 897887738753
## 234159043784408 881388745527
## 234159026266547 237818494899
## 234154821274370 331388745702
## 234159053081262 451388746000
## 234159020233321 911388746146
## 234159014081879 891388746156

&

## 234451388746000 447887738753 (which is not right because the 3rd column of file2 does not have any match in file1)


One more thing I am using cygwin to create unix enviornment on my windows machine & its not actually a unix machine but just unix environment.

Code:

nawk 'NR==FNR{x[$1];next}$3 in x'  file1 file2

Hi I tried the above but I am getting the same out put as I was getting with grep -f

strange - looks fine to me:

Code:

#  cat file1
897887738753
881388745527
237818494899
331388745702
451388746000
911388746146
891388746156


#  cat file2
## 234451388746000 447887738753
## 234159018106564 447818494899
## 234159055332992 897887738753
## 234159043784408 881388745527
## 234159026266547 237818494899
## 234154821274370 331388745702
## 234159053081262 451388746000
## 234159020233321 911388746146
## 234159014081879 891388746156


#  nawk 'NR==FNR{x[$1];next}$3 in x'  file1 file2
## 234159055332992 897887738753
## 234159043784408 881388745527
## 234159026266547 237818494899
## 234154821274370 331388745702
## 234159053081262 451388746000
## 234159020233321 911388746146
## 234159014081879 891388746156


#  nawk 'NR==FNR{x[$1];next}$3 in x'  file1 file2 | wc 
       7      21     225

#  /usr/xpg4/bin/grep -f file1 file2 | wc 
       8      24     257

do you want to post you exact command sequence /output ?

Thanks a lot its working..I am grateful.