Shell Programming and Scripting

Use:

Code:

awk 'NR==FNR{a[$0]++;next}
            ( a[$0] >= 2 ){b[$0]++}
END {
for ( i in  b )
    if ( b[i] == 1 )
       printf("%s\n%s\n%s\n",i,i,i)
}' f1 f2

BTW: use a more descriptive name for your posts.

You need to redirect the output to a file. It is working.

one more feature need to add to this command. example sometimes iam having files as follows.

if case1
file1
aa
aa
aa
aa
ab
ac
ad
ae

file2
aa
aa
aa
aa
ab
ac
ad
ae

Outputfile:
should be empty



if case2
file1
aa
aa
aa
aa
ab
ac
ad
ae

file2
aa
aa
ab
ac
ad
ae

Outputfile:
aa

Note: if file2 contents matches with file1 no output should be created. if file2 has records more than once, it should check that records in the file1.

in the above example. file1 has aa 4 times.

file2 has aa 2 times. then i getting the output file corrcetly
using the command given

Code:

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

but if i am having the files as in case1. then i need to get the output file empty, but using this above command iam getting output as

aa


can i get the suggesions??

help pls????????

Try:

Code:

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

and please do not bump questions.
Regards

It is working great....Thanks for your reply.

Sorry for creating another thread.

The script should check the entire create table definition upto ; and list out the directories names which does not primary index in the definition.

Example:
main directory which has subdirectries also:

/home/surya

File name : abc.text

create table data (pi int, col1 char(1), col2 char(5), col3 int) primary index (pi);

1.Check for Create table upto ;
2.omit primary index if found and display the file names and the directory it was found

Thanks in advance