UNIX for Dummies Questions & Answers

Hi all,

I have a test.dat file.In that file i have many lines of data.
IN between some lines i want to insert a new line while running the test.ksh.

Say for ex:
In the dat file i have data like

N001 100.00
N001 200.00
N001 300.00
N001 400.00 <==
After this line i want to insert line like
N001 1000.00 ( total of all the N001 data).
N002 100.00
N002 200.00
N002 300.00
N002 400.00

Please tell me how i can do this by runnin ga script.

Thanks in Advance,
Sona.

nawk -f sona.awk test.dat

sona.awk:

Code:

FNR==1 {f1=$1}
{
   if ( $1 == f1 )
      t+=$2
   else {
     printf("%s%s%.2f\n", f1, OFS, t); f1=$1; t=$2
   }
}
1
END { printf("%s%s%.2f\n", f1, OFS, t) }

Hi,

Thanks for your response.Can you please explain this piece of code.i could not understand the code.

Thanks,
Sona.