Shell Programming and Scripting

Need help with doing field comparisons.

File1
204.11.23.1 fastmovie.mp4
209.13.1.1 slowmovie.mp4

file 2
NY USA 201.1.1.1 200 freemovie.mp4
CA USA 204.11.23.1 404 notfastmovie.mp4
CA USA 204.11.23.1 200 fastmovie.mp4

basically need to take the first file and find exact matches in field 3 and 5 of the second file and I would print the entire line from file 2. So the output here would only be line 3 of file 2

Hi,

try:

Code:

awk 'NR==FNR{a[$1$2]}{if ($3$5 in a) print $0}' file1 file2

gives me:

Code:

CA USA 204.11.23.1 200 fastmovie.mp4

HTH Chris

Code:

awk 'NR==FNR{a[$1]=$2;next}($5==a[$3])' File1 File2

Ok a couple things. If file 2 is huge on the magnitude of over 6 gig is awk the best way to handle it? finally in file 2 the filename field wouldn't be an exact match in file 2 it would actually be listed like /home/httpd/www/fastmovie.mp4

I have a similar probelm to the OP but need to compare jsut the 1st fields of the 2 files and print out the whole line as he needs. However, I thought i'd try his problem and work from it, but your solution only seems to print out the whole of file 1...could you re-look into this please?

---------- Post updated at 11:01 AM ---------- Previous update was at 10:59 AM ----------

As I stated I have a similar problem, but tried to work through this example to solve mine (I want to compare jsut the 1st field of each file), but your code seems to give a syntax error, although I have it down exactly the same. Any idea's?

Code:

$ cat File1
204.11.23.1 fastmovie.mp4
209.13.1.1 slowmovie.mp4

$ Cat File2
NY USA 201.1.1.1 200 freemovie.mp4
CA USA 204.11.23.1 404 notfastmovie.mp4
CA USA 204.11.23.1 200 fastmovie.mp4

$ awk 'NR==FNR{a[$1]=$2;next}($5==a[$3])' File1 File2
CA USA 204.11.23.1 200 fastmovie.mp4

If on Solaris, use /usr/bin/nawk or /usr/xpg4/bin/awk

What would I need to do to be able to compare just the 1st fields in the 2 files? The whole equals signs confuse me slightly. Many thanks