UNIX for Dummies Questions & Answers

I have a file called mytitles.txt containing a list of book titles
I have a second file called abfile.txt containing a list of book titles (in the 3rd field) and it has author info and copyright year info as well..

I want to search mytitles.txt for a match in the 3rd field of abfiles.txt, and if there is a match found, I want to print that whole line from abfiles.txt to foundfiles.txt...

I would use a for loop like %for i in mytitles.txt do awk ;{if ($i ==$3) print}' or something like that, but as you can see, I don't know how to do this type of for loop in awk.

---------- Post updated at 11:54 AM ---------- Previous update was at 11:20 AM ----------

I should specify the field separator in abfiles.txt is double quotes (") but in mytitles.txt it is simply titles, some with spaces, some a single word.

Can you give example lines from each file?

My File with Titles:

Code:

Close Range
VANISHED MAN 
Cold Moon 
1776
Creating Wealth 
Dante Club

File I want to find matches in with field separator being " so the title would be $2.. If found a match, I want to print the whole line from this file:

Code:

  d5of5 Vanished Man    9780743551717    "VANISHED MAN"    "DEAVER, JEFFERY"    2005
 CD01of10 1776UAB    9780743551779    "1776"    "MCCULLOUGH, DAVID"    2005

----------
the lines above should be printed to a newfile, because they matched with the first file.


I hope I am being clear, thanks for your help.

---------- Post updated 01-26-11 at 09:24 AM ---------- Previous update was 01-25-11 at 01:31 PM ----------

Please remove this thread