Shell Programming and Scripting

HI ALL,

Thanks for helping me with my last post.

I have one more doubt, i want to parse a set of data. which is consisting of some values that occured in particular period of time.
And when i parse down if there is a missing time period then it should show the two rows between which the data is missing.


the example of entries in the table is given below:-
like there is missing data between 04:10:08 and 04:12:08, same way down the list marked in red.

How do i show the missing value of 04:11:08 that falls betweeen 04:10:08 and 04:12:08.

05/29/2008 04:09:08 - avg: 2 max: 5 min: 1 samples: 7 total: 17
05/29/2008 04:10:08 - avg: 7 max: 25 min: 1 samples: 22 total: 161
05/29/2008 04:12:08 - avg: 4 max: 12 min: 1 samples: 9 total: 41
05/29/2008 04:13:08 - avg: 7 max: 51 min: 1 samples: 10 total: 70
05/29/2008 04:14:08 - avg: 2 max: 5 min: 1 samples: 7 total: 17
05/29/2008 04:15:08 - avg: 2 max: 5 min: 1 samples: 7 total: 17
05/29/2008 04:16:08 - avg: 4 max: 13 min: 1 samples: 8 total: 33
05/29/2008 04:18:08 - avg: 4 max: 24 min: 1 samples: 9 total: 42
05/29/2008 04:22:08 - avg: 2 max: 5 min: 1 samples: 7 total: 17
05/29/2008 04:23:08 - avg: 2 max: 5 min: 1 samples: 7 total: 17
05/29/2008 04:24:08 - avg: 2 max: 5 min: 1 samples: 7 total: 17
05/29/2008 04:25:08 - avg: 8 max: 24 min: 1 samples: 18 total: 160
05/29/2008 04:26:08 - avg: 4 max: 12 min: 1 samples: 9 total: 41
05/29/2008 04:27:08 - avg: 2 max: 5 min: 1 samples: 7 total: 17
05/29/2008 04:28:08 - avg: 6 max: 50 min: 1 samples: 11 total: 71
05/29/2008 04:29:09 - avg: 2 max: 5 min: 1 samples: 7 total: 17
05/29/2008 04:30:09 - avg: 2 max: 5 min: 1 samples: 7 total: 17
05/29/2008 04:31:09 - avg: 4 max: 13 min: 1 samples: 8 total: 33
05/29/2008 04:32:09 - avg: 5 max: 24 min: 1 samples: 9 total: 45
05/29/2008 04:33:09 - avg: 3 max: 12 min: 1 samples: 9 total: 30


Thanks a lot.
Adi

And how big will the log be?

For instance, could do something like the following - combination of unix commands and pseudo-code. The following logic would apply best if every hour the log file is 'new' and you want to check for missing items.

Code:

cat logfile | cut -d" " -f2 | cut -d":" -f1-2 >logfile2 # gives hours and minutes

then do a loop
min=0
while [ $min -lt 60 ]
  do
  # see if the hour:$min exists in the logfile2
  # if not, create your warning
  min=((min + 1))
done

The log has about 1000+ lines of entry

1000 lines means one day?
Since 24 hours times 60 minutes = 1440 minutes --> 1440 lines expected

Thus, what I wrote before just needs another loop (outside the minute loop) to cycle thru the hours in a day, from 0 to 23.