I have data which is like the following
Pole Start Date Start time End Date End time
Function Parameters Status Num Of Recs Num Of Sec Num
Of Min
EU 2/1/2000 21:07:06 2/1/2000 21:14:22 L
ACT OK 652.00 436.00 7.27
EU 2/1/2000 21:14:23 2/1/2000 21:14:25 S
ACT 08:F OK 2.00 0.03
EU 2/1/2000 21:14:25 2/1/2000 21:14:56 S
ACT 10:No Company Rollup:F OK 31.00 0.52
EU 2/1/2000 21:14:56 2/1/2000 21:16:15 S
ACT 10:Company Rollup:F OK 79.00 1.32
EU 2/1/2000 21:16:15 2/1/2000 21:16:31 S
ACT 02:No Company Rollup:F OK 16.00 0.27
EU 2/1/2000 21:16:31 2/1/2000 21:16:57 S
ACT 7:Rollup:F OK 26.00 0.43
EU 2/1/2000 21:16:57 2/1/2000 21:17:28 S
ACT 02:Company Rollup:F OK 30.00 0.50
EU 2/2/2000 21:06:41 2/2/2000 21:14:05 L
ACT OK 655.00 445.00 7.42
EU 2/2/2000 21:14:06 2/2/2000 21:14:08 S
ACT 08:F OK 2.00 0.03
EU 2/2/2000 21:14:08 2/2/2000 21:14:56 S
ACT 10:No Company Rollup:F OK 48.00 0.80
EU 2/2/2000 21:14:56 2/2/2000 21:15:34 S
ACT 10:Company Rollup:F OK 38.00 0.63
EU 2/2/2000 21:15:34 2/2/2000 21:15:53 S
ACT 02:No Company Rollup:F OK 19.00 0.32
EU 2/2/2000 21:15:53 2/2/2000 21:16:12 S
ACT 7:Rollup:F OK 19.00 0.32
EU 2/2/2000 21:16:12 2/2/2000 21:16:26 S
ACT 02:Company Rollup:F OK 15.00 0.25
EU 2/3/2000 14:33:43 2/3/2000 14:40:13 L
ACT OK 1,958.00 390.00 6.50
EU 2/3/2000 14:40:14 2/3/2000 14:40:19 S
ACT 08:F OK 6.00 0.10
EU 2/3/2000 14:40:20 2/3/2000 14:44:25 S
ACT 10:No Company Rollup:F OK 245.00 4.08
EU 2/3/2000 14:44:25 2/3/2000 14:52:29 S
ACT 10:Company Rollup:F OK 484.00 8.07
EU 2/3/2000 14:52:29 2/3/2000 14:55:53 S
ACT 02:No Company Rollup:F OK 203.00 3.38
EU 2/3/2000 14:55:53 2/3/2000 14:57:59 S
ACT 7:Rollup:F OK 126.00 2.10
EU 2/3/2000 14:57:59 2/3/2000 15:00:41 S
ACT 02:Company Rollup:F OK 162.00 2.70
I want to apply a break everytime I get a value L in the function column
i.e I would want it split like below so that I can calculate the totals for each logical set of data( which is evident by the presence of value L). THe number of rows with value S can vary .
Pole Start Date Start time End Date End time
Function Parameters Status Num Of Recs Num Of Sec Num
Of Min
EU 2/1/2000 21:07:06 2/1/2000 21:14:22 L
ACT OK 652.00 436.00 7.27
EU 2/1/2000 21:14:23 2/1/2000 21:14:25 S
ACT 08:F OK 2.00 0.03
EU 2/1/2000 21:14:25 2/1/2000 21:14:56 S
ACT 10:No Company Rollup:F OK 31.00 0.52
EU 2/1/2000 21:14:56 2/1/2000 21:16:15 S
ACT 10:Company Rollup:F OK 79.00 1.32
EU 2/1/2000 21:16:15 2/1/2000 21:16:31 S
ACT 02:No Company Rollup:F OK 16.00 0.27
EU 2/1/2000 21:16:31 2/1/2000 21:16:57 S
ACT 7:Rollup:F OK 26.00 0.43
EU 2/1/2000 21:16:57 2/1/2000 21:17:28 S
ACT 02:Company Rollup:F OK 30.00 0.50
SUM
EU 2/2/2000 21:06:41 2/2/2000 21:14:05 L
ACT OK 655.00 445.00 7.42
EU 2/2/2000 21:14:06 2/2/2000 21:14:08 S
ACT 08:F OK 2.00 0.03
EU 2/2/2000 21:14:08 2/2/2000 21:14:56 S
ACT 10:No Company Rollup:F OK 48.00 0.80
EU 2/2/2000 21:14:56 2/2/2000 21:15:34 S
ACT 10:Company Rollup:F OK 38.00 0.63
EU 2/2/2000 21:15:53 2/2/2000 21:16:12 S
ACT 7:Rollup:F OK 19.00 0.32
SUM
EU 2/3/2000 14:33:43 2/3/2000 14:40:13 L
ACT OK 1,958.00 390.00 6.50
EU 2/3/2000 14:40:14 2/3/2000 14:40:19 S
ACT 08:F OK 6.00 0.10
EU 2/3/2000 14:40:20 2/3/2000 14:44:25 S
ACT 10:No Company Rollup:F OK 245.00 4.08
EU 2/3/2000 14:44:25 2/3/2000 14:52:29 S
ACT 10:Company Rollup:F OK 484.00 8.07
EU 2/3/2000 14:52:29 2/3/2000 14:55:53 S
ACT 02:No Company Rollup:F OK 203.00 3.38
EU 2/3/2000 14:55:53 2/3/2000 14:57:59 S
ACT 7:Rollup:F OK 126.00 2.10
EU 2/3/2000 14:57:59 2/3/2000 15:00:41 S
ACT 02:Company Rollup:F OK 162.00 2.70
SUM
Any Suggestions
thanks
guna
Listserv Archives (BOB member since 2002-06-25)