I have two files x and y containing two fields emp number and emp name in each file. I want to bring out the mismatching entries and missing entries into a file. File x has the correct emp number and emp name. y has correct emp number but name is not correct or blank or correct. I used comm -13 x y > z1 and comm -13 x y >z2. The out put files now consists of unique fields in file x and file y. But i want the print output as emp number , emp name in file1 , emp name in file2 for comparing the emp names. The x and y files has more than 50000 lines.
I heard that through awk program we can do that but i couldn't achieve it. I could print either file z or file z1. but not combined output as required.
I would be thankful if you guide me at the earliest.
linux, awk programs
September 30, 2012 4:22 PM
October 1, 2012 12:03 PM