I would like to know whether VBA Excel could process a
text file containing the SCADA event log and come-up
with a process output as shown below. I am currently
trying to manipulate it via MySQL text import. I hope
somebody already encounter a problem like this. Please
view the sample without word-wrap in notepad. Thanks

SCADA Event Log (saved as pure ASCII text file named
"scada.log")
---------------
12/1/04 0:14:23 505 Avenue Park 425PD4 34.5 kV Open
Abnormal
12/1/04 0:16:31 116 Avenue Park 425PD4 34.5 kV Closed
Normal
12/1/04 0:18:39 505 Avenue Park 425PD4 34.5 kV Open
Abnormal
12/1/04 0:18:41 116 Avenue Park 425PD4 34.5 kV Closed
Normal
... more events

Expected Output (saved into a sheet column A through G
---------------
Date Station Feeder Volt Open Closed
Duration
12/1/04 Avenue Park 425PD4 34.5 kV 0:14:23 0:16:31
0:02:08
12/1/04 Avenue Park 425PD4 34.5 kV 0:18:39 0:18:41
0:00:02
... more output