Addition of marks

[kevmullet]

i need to add some column together from the following format:

960002323
01 10
02 8
03 10
04 6
05 9
06 0

i have to add the second column together to make it look like :

960002323 43

i have a number of blocks of marks (its an exam marking system)

thanks for any help

 

[grega]

Here's one quick & dirty way

Create an awk script with the following code (lets call it marks.awk)

NR==1 {id=$1}
NF==1 && NR==1 {tot=0;id=$1}
NF==1 && NR != 1 {print id,tot;tot=0;id=$1}
NF==2 {tot+=$2}
END {print id,tot}

Then run the script against the input file using awk -f marks.awk inputfile

Greg.

 

[grega]

In fact you can probably ditch the 1st line ...

NF==1 && NR==1 {tot=0;id=$1}
NF==1 && NR != 1 {print id,tot;tot=0;id=$1}
NF==2 {tot+=$2}
END {print id,tot}

Greg.