Shell Programming and Scripting

#1 (**permalink**) 02-19-2008

Hi,

Iam having the files as follows:

file1
aa
aa
aa
aa
ab
ac
ad
ae

file2
aa
aa
ab

Outputfile:
aa
aa

Actually i want to track the file1 and file2 for common records.

output file should get the records that are in file1 and not in file2. Here 4 aa's are there in file1. and 2 aa's are in file2. i jus want to get " 2 aa's in file1 and 4 aa's in file2. so we need to track this aa." like this message should come in the o/p file.

Can anybody help??

manikantants · #2 (**permalink**) 02-19-2008

Quote:

Originally Posted by nivas

i jus want to get " 2 aa's in file1 and 4 aa's in file2. so we need to track this aa." like this message should come in the o/p file.

It should be " 2 aa's in file2 and 4 aa's in file1. so we need to track this aa.". Isn't it ?

And if you need such a message in the o/p file, awk will help you.

#3 (**permalink**) 02-19-2008

i don't want any messages in o/p file. i just want to tract those records that occur in file1 and file2 more than once.

pls give the help

manikantants · #4 (**permalink**) 02-19-2008

cat file1 | uniq -c | awk '{ if ($1>1) print $2}'

Klashxx · #5 (**permalink**) 02-19-2008

Try:

Code:

awk 'NR==FNR{a[$0]++;next}
            ( a[$0] >= 2 ){b[$0]++}
END {
for ( i in  b )
    if ( b[i] >= 2)
       print i
}' file1 file2

Klashxx · #6 (**permalink**) 02-19-2008

Quote:

Originally Posted by nivas

i just want to tract those records that occur in file1 and file2 more than once.

See the difference:

Code:

> cat f1
aa
aa
aa
aa
ab
ac
ac
ad
ae
> cat f2
aa
ab
ac
ac

Code:

> paste f1 f2 |awk '{if ($1 == $2) print $1}'
aa

Or:

Code:

>awk 'NR==FNR{a[$0]++;next}
            ( a[$0] >= 2 ){b[$0]++}
END {
for ( i in  b )
    if ( b[i] >= 2)
       print i
}' f1 f2
ac

#7 (**permalink**) 02-19-2008

This awk command is not showing any output.

awk 'NR==FNR{a[$0]++;next}
( a[$0] >= 2 ){b[$0]++}
END {
for ( i in b )
if ( b[i] >= 2)
print i
}' file1 file2

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Shell Programming and Scripting	nivas	Shell Programming and Scripting	21	02-25-2008 06:27 AM
Shell Programming and Scripting	nivas	Shell Programming and Scripting	2	02-20-2008 02:59 AM
Shell Programming and Scripting	nivas	Shell Programming and Scripting	14	02-20-2008 02:07 AM
Shell Programming and Scripting	nivas	Shell Programming and Scripting	3	02-13-2008 08:10 AM
Shell scripting & programming languages	aloysius1001	UNIX Desktop for Dummies Questions & Answers	1	02-19-2002 12:04 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: