topic Re: Match two files in Operating System - HP-UX

Match two files

Intothenewworld — Tue, 10 Apr 2012 06:09:47 GMT

I have two files , the content is as below , I would like to list the lines in file2 , that the lines the file1 have , as the below , both files have aaaa , cccc , eeee , so the output is the line which have aaaa , cccc , eeee , can advise what can i do ? thx

file1
=====
aaaa
bbbb
cccc
dddd
eeee

file2
=====
aaaa 1111
cccc 2222
eeee 3333

my desired result is as below
=============================
aaaa 1111
cccc 2222
eeee 3333

Re: Match two files

Dennis Handly — Tue, 10 Apr 2012 22:43:38 GMT

You can simply use: fgrep -f file1 file2

if you are worried about substrings in file1 that may match multiple lines in file2, you can add -w:

grep -w -f file1 file2

Re: Match two files

RAJD1 — Wed, 11 Apr 2012 05:01:14 GMT

Hi There, you can try this with awk:

$ awk 'NR==FNR {a[$1]=$1;next} {print a[$1],$2}' file1 file2

Cheers,

Raj D.