Comparing two files

Bartonsen · 10-28-2016, 09:25 AM

I have two files which I want to compare, and display the common.

file1:
0010
0010
0010
1213
7010
7010
8732
8732
8732

file2:
0010 hello
0020 world
0130 this is
0140 just some
1213 randow text
1214 to prove that
1215 someone can
7010 fix
7019 my issue
8732 thanks in
9732 advance

The output should be:
0010 hello
0010 hello
0010 hello
1213 randow text
7010 fix
7010 fix
8732 thanks in
8732 thanks in
8732 thanks in

I have tried with "grep -f file1 file2" but the output shows only 1 line per match:
0010 hello
1213 randow text
7010 fix
8732 thanks in

The first word is always a 4 digit word in both files.
I want to print the line from file2 each time there is a match from the word in file1.

allend · 10-28-2016, 09:32 AM

Welcome to LQ!

Have you looked at the 'join' command?

MensaWater · 10-28-2016, 09:37 AM

You could do it with a while loop:

Code:

while read val
do grep $val file2
done <file1

or explore the join command. "man join"

jpollard · 10-28-2016, 09:37 AM

Or maybe the "comm" command?

Bartonsen · 10-28-2016, 11:27 AM

Thanks for the suggestions. It looks like join is what I've been looking for. Will test it out.

frankbell · 10-28-2016, 05:21 PM

There's also diff and meld, a sort of GUI diff.

Bartonsen · 10-31-2016, 02:37 PM

It turned out join was the easiest solution, and gave me the wanted output.
Thanks for all suggestions.

MensaWater · 11-01-2016, 01:04 PM

Quote:

Originally Posted by Bartonsen

It turned out join was the easiest solution, and gave me the wanted output.
Thanks for all suggestions.

Please go to thread tools and marked this is as Solved. Also you might want to post the exact usage of join you used so others finding this thread in future can see it in light of your example files.