Shell Programming and Scripting

2008 Tue Apr 22 00:11:50
1.0
2.1
4.0
2008 Tue Apr 22 00:26:51
4.0
5.0
6.2

With the above as the input file, I would like to output:
2008 Tue Apr 22 00:11:50
7.1
2008 Tue Apr 22 00:26:51
15.2

In other words add the (numeric) records between the records that start with 2008 (all the dates start with 2008 in this data).

Tried a couple of variations on:

Code:

/^2008/ { total = 0; print$0; getline; while ($1 != "2008") {total += $1; getline}; print total }

Can't get it right - when the while loop condition becomes false processing resumes after the date which made it so, and hence that date it skipped and it proceeds in this way to only print every second date with associated total.
That's not very clear, sorry about that. Any help appreciated.

Code:

 awk '{ if(/^2008/) { print total; total=0; print $0}
                     else { total+=$0}
        ' filename

This should give you the desired output:

Code:

awk '
NF==1{s+=$0;next}
s{print s;s=0}1
END{print s}' file

Use nawk or /usr/xpg4/bin/awk on Solaris.


Regards

Great, many thanks guys, that really helps me out.

Hi Franklin,

Can you please eloborate on the third line of your script.

s{print s;s=0}1

I cant get the significance of 1 at the end.

Thanks in advance

awk evaluate the 1 as a true and by default it prints the whole line, it's similar to {print $0}.

Regards