Calculating time between successful data transmissions
Hi - I need a little help devising something that will
basically do the following:
I have a set of dates of transmissions and I want to find
the time between successful transmits. See below:
11/11/04 6:01 DIAL 1-800-827-1159
11/11/04 6:02 Nothing was received.
11/11/04 6:04 DIAL 1-800-827-1159
11/11/04 6:07 DIAL 1-800-827-1159
11/11/04 6:10 DIAL 1-800-827-1159
11/11/04 6:14 DIAL 1-800-827-1159
11/11/04 6:17 DIAL 1-800-827-1159
11/11/04 6:18 Nothing was received.
11/11/04 6:20 DIAL 1-800-827-1159
11/11/04 6:24 DIAL 1-800-827-1159
11/11/04 6:25 Nothing was received.
11/11/04 6:27 DIAL 1-800-827-1159
11/11/04 6:29 2 file(s) received.
11/11/04 6:29 Transmitted Records Deleted from Output
Queues
11/11/04 6:31 DIAL 1-800-827-1159
11/11/04 6:35 DIAL 1-800-827-1159
11/11/04 6:38 DIAL 1-800-827-1159
You can see that if a transmission is considered
successful, there is some text between the Dialings
(nothing was recieved, 2 files recieved, transmitted
records deleted..., etc). Only when there is nothing
between Dialings was it unsuccesful. How could I go about
creating something that would find the time between
successful sendings? Any help is greatly appreciated.
Donnie.
|