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