sed or awk for arithmetic task

Shell Programming and Scripting
1

I have file with this type of format

01.02.09 08:30
bob
jill
mark

01.04.09 07:00
bob
jill
mark
tom

I want to count the names after the date /ime line (01.02.09 08:30) and add that number after the time like this

01.02.09 08:30 3
01.04.09 07:00 4

I don't care about the names after the count so I can leave them or strip the out with sed if it simplifies the process. I could also redirect the output of date/time and count to second file if it makes it simpler. The only thing I really need is the date/time and number on the same line.

What is the best tool to accomplish this and can someone provide an example?

2 
nawk 'BEGIN {RS=FS=""} {print $1, NF-1}' myFile
3

Nice...

I had to add space to "" and change NF-1 to NF-2 to get accurate count for all lines except the last and first entry. NF-1 gives the correct output for the last line count only. I have 9,000 lines so I having the last and first wrong is not significant issue.

The next problem is that output only has the time in the line like this:

10:00 4
11:00 6

I need the date in the output. Currently looking through the nawk manual to figure out how to combine time and date into output. Any quick suggestions? BTW, running nawk 1.3.3 from Ubuntu 8.10

4

input:

01.02.09 08:30
bob
jill
mark 

01.04.09 07:00
bob 
jill 
mark
tom

01.02.09 09:30
bob
jill
mark 
hj
gh
fm

01.04.09 10:00
bob 
jill 
mark
tom
aaa
bbb
ccc

output:

01.02.09 08:30 3
01.04.09 07:00 4
01.02.09 09:30 6
01.04.09 10:00 7

code:

#!/usr/bin/perl
$/="\n\n";
open FH,"<a.txt";
while(<FH>){
	my @temp=split("\n",$_);
	print $temp[0]," ",$#temp,"\n";
}

awk '/[0-9]*\.[0-9]*\.[0-9]* [0-9][0-9]:[0-9][0-9]/{
	a=$0
	next
}
/^ *$/{
	print a" "n
	n=0
	next
}
{
 n++
}
' a.txt
5

Hmmm.. very strange...
mar.txt:

01.02.09 08:30
bob
jill
mark

01.04.09 07:00
bob
jill
mark
tom

nawk 'BEGIN {RS=FS=""} {print $1, NF-1}' mar.txt

output:

01.02.09 08:30 3
01.04.09 07:00 4

Looks fine to me. Post your input file (or a portion of it) using vB Code tags.

6

Using the same data you had example, I got the following:

nawk 'BEGIN {RS=FS=""} {print $1, NF-1}' data.txt
0 27
0 31

Adding space to ""

$ nawk 'BEGIN {RS=FS=" "} {print $1, NF-1}' data.txt
01.02.09 0
08:30 4
07:00 4

Changing to NF-2

$ nawk 'BEGIN {RS=FS=" "} {print $1, NF-2}' data.txt
01.02.09 -1
08:30 3
07:00 3

7

summer_cherry awk and perl script worked perfectly as-is... I just need to understand how you did it...thanks...