file comparision by line

aaysa123 · #1 (**permalink**) 11-20-2008

i have two files and i want to compare these two
it shoud print those lines which are not in 2nd file
a.txt
1236,AB,0
2345,CD,1
5679,EF,1
9123,AA,1
9223,AA,0

b.txt
1234,AB,0
2345,CD,1
5678,EF,1
9123,AA,0
o/p
1236,AB,0
5679,EF,1
9123,AA,1
9223,AA,0

mailme0712 · #2 (**permalink**) 11-20-2008

Hi,

use the following command

comm -23 <(sort file1) <(sort file2)

Thanks,

Thangaraju

zaxxon · #3 (**permalink**) 11-20-2008

All line of file1 are also in file2; maybe you meant it vice versa:

Code:

grep -vf file1 file2
B,0
5678,EF,1
9123,AA,0
o/p

Else just switch the position of the files in the grep command.

yongitz · #4 (**permalink**) 11-20-2008

I hope it's not homework. A simple grep command will do the task..

Code:

grep -vf b.txt a.txt

::EDIT:: oopppss! same answer with d above post

aaysa123 · #5 (**permalink**) 11-20-2008

thanks for reply but can we do it using nawk as grep -v is not running

yongitz · #6 (**permalink**) 11-20-2008

If you can't use grep then try the comm command given above with a little modification

Code:

comm -23 a.txt b.txt

cdfd123 · #7 (**permalink**) 11-21-2008

if u have two files
first file and second file

awk command will be

awk 'BEGIN {while (getline <"first file") {arr[$0]++}}
{ if (!($0 in arr) {print }}' second file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
file size comparision local file and remote file	dba.admin2008	Shell Programming and Scripting	4	11-13-2008 05:57 PM
Problem with reading file line-by-line, and outputting to a new file	Darkness Fish	Shell Programming and Scripting	4	07-18-2008 07:54 AM
while - comparision	sharif	Shell Programming and Scripting	2	11-01-2007 05:58 AM
Unix File Comparision	coolguy01	Shell Programming and Scripting	5	08-29-2006 03:35 AM
File Comparision by using Shell Script	nvkuriseti	Shell Programming and Scripting	3	08-31-2005 04:05 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by