compare first column of 2 files with awk

Vthimmap · 11-09-2012, 12:50 AM

Need to compare first column of 2 files using awk
sample file1:
ECDLY 5
DBGO 0
ATDLM -10000
LDTHB 4
OMSTD 1

sample file2:
ECDLY 5
DBGBB 0
ATDLM -10000
LDTHB 4
OMSTD 1
AABLO 8
INDCL 4

Vthimmap · 11-09-2012, 01:21 AM

And i need the output in result.txt file

druuna · 11-09-2012, 01:30 AM

A few questions:

- Does it have to be awk?
- What needs to go in results.txt? Entries present in both or those not in file1 or those not in file2?
- Should column 2 be included in results.txt?

Details please.

Vthimmap · 11-09-2012, 01:34 AM

Any command in unix is fine (other than awk )
result.txt - what is not present in file1 with respect to file 2

yes column 2 should be included.

druuna · 11-09-2012, 01:39 AM

Have a look at this:

Code:

comm -13 <(sort file1) <(sort file2) > results.txt

Vthimmap · 11-09-2012, 02:59 AM

Hey this is really working .
Thanks a lot
cheers