HI
I have input file as

 
date 22jan2011
calc                0             667788.1       998877.2
vals     1            222             444             666             777            999
vals     2            222             444             666             777            999
vals     3            222             444             666             777            999

date 22jan2011
calc                22                 0                  0
vals     1            222             444             666             777            999
vals     2            222             444             666             777            999
vals     3            222             444             666             777            999

calc                22                 667788.1       998877.2
vals     1            222             444             666             777            999
vals     2            222             444             666             777            999
vals     3            222             444             666             777            999

Hi Indra2011,

1.- Remove date.
2.- Sum values of 'calc' row.
3.- Print all other rows from any file.

Is like that?

Regards,
Birei

any help!!!!



---------- Post updated at 10:15 AM ---------- Previous update was at 10:14 AM ----------

any help...!!!!
any script with anyone!!!!

Here's a simple awk that will do what Birei suggested:

awk '
    /date/ { next; }
    /calc/ {
        sum[1] = 0;
        for( i = 2; i <= NF; i++ )
            sum[i] += $(i);
        next;
    }
    NR == FNR {
        hold[++hidx] = $0;
        next;
    }

    END {
        printf( "calc\t" );
        for( i = 2; i <= length( sum ); i++ )
            printf( "%.1f\t", sum[i] );
        printf( "\n" );
        for( i = 1; i <= hidx; i++ )
            printf( "%s\n", hold[i] );
    }
'