awk/sed search lines in file1 matching columns in file2

floripoint · #1 (**permalink**) 12-17-2008

Hi All,

as you can see I'm pretty new to this board.

I'm struggling around with small script to search a few fields in another file.

Basically I have file1 looking like this:

Code:

15:38:28 sz:10001 pr:14.16
15:38:28 sz:10002 pr:18.41
15:38:29 sz:10003 pr:19.28
15:38:30 sz:10004 pr:82.46

These lines are already unique and a result from a different script.
What I want to do is:
I want to search file2 for each column of file1 and print the lines from file 2 where all 3 columns of file1 are matching.
I know it sounds easy, but for some reason I'm not sure how I should address the search to use columns. file2 has a completely different structure then file1, but also contains these values.

Here is an example line from file2:

Code:

15:38:29.503~19::1858398671105952::General::Client_ReceivedObject:Depth file : textexttext na:Text side:Textindex:0 action:Delete endtr:0 ts: exid: nrord:1 sz:10003 pr:19.28

I hope somebody can point me to the right direction.

jim mcnamara · #2 (**permalink**) 12-17-2008

Code:

awk '{ print $1 > "f1"
          print $2 > "f2"
         print $3 > "f3" } ' file1
grep -f f1 file1 | grep -f f2 | grep -f f2 > searchresult.txt

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Search, replace string in file1 with string from (lookup table) file2?	gstuart	Shell Programming and Scripting	9	06-08-2009 07:11 AM
Awk Compare File1 File2 on f2	RacerX	Shell Programming and Scripting	4	10-27-2008 09:50 AM
extracting lines from a file1 which maches a pattern in file2	smriti_shridhar	Shell Programming and Scripting	11	07-31-2008 01:56 AM
Awk Compare f1,f2,f3 of File1 with f1 of File2	RacerX	Shell Programming and Scripting	6	11-09-2007 01:34 AM
delete lines from file2 beginning w/file1	michieka	Shell Programming and Scripting	13	06-24-2003 02:42 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by