Comparing 2 files

ravi_nandula · 07-06-2012, 02:10 AM

Hi everyone,

I have same problem with the comparing 2 files .
My requirement is ...

cat 1234
1
2
3
4
5
6
67
7
............
cat file1
1
3
5
67
...........................
Now I want "file1" to compare with "1234"...
1 is present in both the file so it should be printed
but 7 is not there in the "file1" so it should not be printed.

so can anyone help me to do this.

Thanks in Advance

jschiwal · 07-06-2012, 02:18 AM

If you want common lines printed, look at the "comm" command. The two files need to be sorted.
comm -12 <(sort file1) <(sort file2)

The command normally prints out 3 columns; unique to the first file, unique to the second, common to both. The -12 options suppresses the first 2 columns of output leaving just the lines common to both.

jsaravana87 · 07-06-2012, 02:22 AM

You can compare the file using sdiff

#sdiff 1324 file1

ravi_nandula · 07-06-2012, 02:23 AM

Quote:

Originally Posted by jschiwal

If you want common lines printed, look at the "comm" command. The two files need to be sorted.
comm -12 <(sort file1) <(sort file2)

The command normally prints out 3 columns; unique to the first file, unique to the second, common to both. The -12 options suppresses the first 2 columns of output leaving just the lines common to both.

thanks for immediate reply.
actually I have one file with 500 host names and other file with list of 200 host names.
I want to find whether the 2nd set of 200 host names are present in the 1st file of 500 host name....

when I trying to use the command which u get gave....it's showing me the error msg " file 2 not in sorted order"......."file 1 not in sorted order"

jschiwal · 07-06-2012, 02:46 AM

If you are interested in items in list 2 not in list 1, you want items unique to list 2, so suppress columns 1 & 3; comm -13.

Show the command you entered because my example used the sort command.

If you want new items in list 2 added to list 1, then create a temporary file catting the unique list with file1, then mv the temp file to file1.

P.S.
try adding the "-u" option to the sort commands.
comm -12 <(sort -u file1) <(sort -u file2)

grail · 07-06-2012, 02:54 AM

How about:

Code:

grep -f 200_file 500_file | wc -l

montel · 07-09-2012, 10:31 AM

Try this:

Code:

i=0
while read line ; do
        output=`echo $line`
        if [[ -n "$output" ]]
        then
                myarray[$i]=$output
                i=`expr $i + 1`
        fi
done < "1234"

while read line ; do
        match=0
        dat=`echo "$line"`
        if [ -n "$dat" ]
        then
                for (( x=0 ; x < ${#myarray[@]} ; x++ )) do
                        if [ "${myarray[$x]}" == "$dat" ]
                        then
                                match=1
                                echo ${myarray[$x]}
                        fi
                done
        fi
        if [ $match = 0 ]
        then
             echo "no match"
        fi
done < "file1"

I believe that should accomplish what you want

Alchemikos · 07-09-2012, 12:39 PM

Quote:

Originally Posted by ravi_nandula

thanks for immediate reply.
actually I have one file with 500 host names and other file with list of 200 host names.
I want to find whether the 2nd set of 200 host names are present in the 1st file of 500 host name....

when I trying to use the command which u get gave....it's showing me the error msg " file 2 not in sorted order"......."file 1 not in sorted order"

Hello

I must sort first , as said before

:

Code:

sort 1234 > fa ; sort file1 > fb ; comm -12  fa fb > out ; nano out

Cheers