Help me to write the script

Shell Programming and Scripting
1

Actually i am working with two diffrent files having same structure
each file contain Ten diffrent column and i want to write a script
which will compare the colummns of first file with the column of second file and diiference will be send to the first column of third file .

similarly for other columns ......
the third file is having the same structure as the previous two files..

2

Please give us an example.

3

Can you get me the script of comparing data in two sheets.

Say for eg

column A,,,,,, for sheet 1

column B,,,,,, for sheet 2

I want all the columns of sheet 1 should be compared with sheet 2 (both the sheet are having same columns & structure)

Wherever data is mismatching it should give me the details in any 3rd sheet .

4

Please give us a full example.
Input files with many rows, and expected output file.

5

HI,
To be honest, you did not give out the detail requirements. Suppose it is as follow (remember give example if possible).

input:

a:
a b c d e f g
b c d e f g h
c d e f g h i
2 b 4 d 5 f 7
b:
b c d e f g h
g d e f g h i
k e f g h i j

output:

    a     e     c
    c           4
    2           f
    g
    k

code:

cat a b >c
nawk '{
if (a=="")
        a=sprintf("%s",$1)
else
{
        if (index(a,$1)==0)
                a=sprintf("%s,%s",a,$1)
        else
        {
                a=sprintf("%s%s",substr(a,1,index(a,$1)-1),substr(a,index(a,$1)+2,length(a)-index(a,$1)-1))
        }
}
if (b=="")
        b=sprintf("%s",$2)
else
{
        if (index(b,$2)==0)
                b=sprintf("%s,%s",b,$2)
        else
                b=sprintf("%s%s",substr(b,1,index(b,$2)-1),substr(b,index(b,$2)+2,length(b)-index(b,$2)-1))
}
if (c=="")
        c=sprintf("%s",$3)
else
{
        if (index(c,$3)==0)
                c=sprintf("%s,%s",c,$3)
        else
                c=sprintf("%s%s",substr(c,1,index(c,$3)-1),substr(c,index(c,$3)+2,length(c)-index(c,$3)-1))
}
}
END{
split(a,arr,",")
split(b,brr,",")
split(c,crr,",")
for (i=1;i<=10;i++)
printf("%5s %5s %5s\n",arr,brr,crr)
}' c
rm c
6

Hi summer you picked the right one ....
the example is pretty good .......

Because of my busy schedule i am unable to posted the examples..
Thanks a lot