Shell Programming and Scripting

I am using solaris, need either awk/shell or perl script to compate two files.
both of these file1 and file2 are located in two diffent location path in the same server.
file1 location: /export/db/mna
file2: /etc/dba

The script will compare in file1 first field (e.g. abc00asp)before colon:
and will look for match in file2 second field (e.g. abc00asp)


File1 format:


abc00asp:11.83.0.1
def01asp:11.83.0.2
efg00asy:11.83.0.5
rkl01atm:11.83.0.6
ppr00rsm:11.83.0.7
trt00nsm:11.83.0.8



File2 Format:

172.25.0.97 abc00asp abc00asp.atl.mnn.net
172.25.0.97 ppr00rsm ppr00rsm.atl.mnn.net
172.25.0.97 bppr00rsm pr00rsm.atl.mnn.net
172.25.0.97 ypr00rsm ppr00rsm.atl.mnn.net
172.25.0.97 ppr00rsm ppr00rsm.atl.mnn.net
172.25.0.97 trt00nsm trt00nsm.atl.mnn.net


The outfile will indicate match files:


abc00asp
ppr00rsm
trt00nsm


Thank you.

Code:

> cat file261
abc00asp:11.83.0.1
def01asp:11.83.0.2
efg00asy:11.83.0.5
rkl01atm:11.83.0.6
ppr00rsm:11.83.0.7
trt00nsm:11.83.0.8

> cat file262
172.25.0.97 abc00asp abc00asp.atl.mnn.net
172.25.0.97 ppr00rsm ppr00rsm.atl.mnn.net
172.25.0.97 bppr00rsm pr00rsm.atl.mnn.net
172.25.0.97 ypr00rsm ppr00rsm.atl.mnn.net
172.25.0.97 ppr00rsm ppr00rsm.atl.mnn.net
172.25.0.97 trt00nsm trt00nsm.atl.mnn.net

> cat comp_261_262 
#! /usr/bin/bash

cut -d":" -f1 file261 | sort >file261a
cut -d" " -f2 file262 | sort >file262a

comm -12 file261a file262a

> comp_261_262 
abc00asp
ppr00rsm
trt00nsm
>

comp_261_262 is the actual script file, after running the script it creates 2 files:
file261a and file262a


but I dont understand how u get here:
how did u find the match result.


> comp_261_262
abc00asp
ppr00rsm
trt00nsm
>

That is the name of a short script I wrote. Perhaps it all could have been done in one command, but it is easier to see with the three commands inside one executable file.

The file contains:
#! /usr/bin/bash

cut -d":" -f1 file261 | sort >file261a
cut -d" " -f2 file262 | sort >file262a

comm -12 file261a file262a

the first part sets the version for scripting
then two cut commands to get to the important part of each file
finally, the comm command to show what is in common

well, this cut -d" " -f2 file262 | sort >file262a does not isolate the files 2nd field.
There is a tab inbetween for this file data.

But I am still could not get the result of matching field.

As below, could change the tab to a space, so the previous logic would work.

Code:

> cat comp_261_262 
#! /usr/bin/bash

cut -d":" -f1 file261 | sort >file261a
tr "\t" " " <file262 | cut -d" " -f2 | sort >file262a

comm -12 file261a file262a

Could also use awk to take apart the two input files. Awk treats space characters and tab characters as delimiters.

It works this time, since TAB logic fixes it.
One more help how can I reverse the logic so that ONLY UN-MATCH items shows up.

thanks and appreciate it very much.