comparing columns in 2 files 1

[Mag0007]

I have file1:

foo:user1:foo
foo:user4:foo
foo:user2:foo
foo:user6:foo

file2:

user2
user3
user1

Desired output:

user2 exists in file1
user3 does NOT exist in file1
user1 exists in file

Any way to do this with awk?

TIA

 

[Annihilannic]

awk -F: '
BEGIN {
        # Read file1 into an array
        while (getline < "file1") {
                users[$2]=1
        }
}
{
        # For every line in file2, test for presence and
        # display result
        if (users[$1])
                print $1 " exists in file1"
        else
                print $1 " does NOT exist in file1"
}
' file2

Annihilannic.

 

[PHV]

awk -F: 'NR==FNR{a[$2];next}{print $1 ($1 in a ? " exists" : " does NOT exist") " in file1"}' file1 file2

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886