Parsing a Tabbed Database (columns) Question...

General · July 18, 2005, 4:38pm

Hello,

I’m trying to write an Applescript that will parse out information from either an ALE or FTL file (they are film telecine files that I’ll paste samples of below). They are essentially tabbed files. Unfortunately, I’ve only figured out how to parse information out on a line by line basis (which is used in FLEX files, another type of telecine file).

Anyway, how do I pull info from columns (and keep track of it?)? And in the case of an ALE, how do you skip the header information?

Here is a sample of a FTL file (Note Event 1 is an empty event, so there is no info in many fields):

Record# EVENT CAMROLL SOUNDROLL DOP SCENE TAKE VTTC_IN VTTC_OUT DURATION
1 0 2.0 2.0 09/14/95
2 1 LDR MOS 03/02/05 X-FRAM 1 14:00:00:00 14:00:04:00 00:04:00
3 2 A114 MOS 03/02/05 96 4 14:00:04:00 14:01:55:10 01:51:10

And etcetera. I want the CAMROLL, SCENE, TAKE, VTTC_IN, and VTTC_OUT. The rest of the fields I don’t need.

And ALE file looks like this (this is a tabbed file, some of the lines are wrapped, like the one under column:

Heading
FIELD_DELIM TABS TRACKER_VERSION 1.6.001 Sort Order: [Tag]
VIDEO_FORMAT NTSC
FILM_FORMAT 35mm,4perf
AUDIO_FORMAT
TAPE 001
FPS 24

Column
Name Tracks Tape FPS Start End Duration Labroll Camroll Dailyroll Shoot Date Sound TC Soundroll Scene Take Slate Descript Comments KN Start KN End Pullin Ink Number TC 24

Data
PUNCH-1 VA1A2 001 24 01:00:00:00 01:00:13:05 00:00:13:05 A001 08/17/04 08:08:32:17 001 PUNCH 1 DAY ONE EH536453-3955+00 EH536453-3974+12 AA 01:00:00:00
23AA-3A VA1A2 001 24 01:00:13:00 01:01:25:00 00:01:12:00 A001 08/17/04 08:14:19:25 001 23AA 3A EH536453-4197+06 EH536453-4305+06 AA 01:00:13:00
23AA-4A VA1A2 001 24 01:01:25:10 01:02:40:05 00:01:14:25 A001 08/17/04 08:17:25:28 001 23AA 4A EH536453-4306+11 EH536453-4418+15 AA 01:01:25:08
23AA-5A VA1A2 001 24 01:02:40:10 01:03:52:05 00:01:11:25 A001 08/17/04 08:20:11:28 001 23AA 5A EH536453-4421+01 EH536453-4528+13 AA 01:02:40:08

So, there’s a header. The meat of the data is below the “Data” although the column names are in the 'Column" section.

I’ve read through 5 Applescript books, and I can do the tab delimiters and all that. Just the column data has me absolutely perplexed.

Thanks.

Adam_Bell · July 18, 2005, 5:47pm

If the column names are always the same, why not name lists with those names and read the data into the lists so that item 1 of column 1 corresponds to item 1 of column 2, etc.?

Brad_Bumgarner · July 18, 2005, 7:51pm

There are a few different ways to tackle a project like this.

First, how many lines are typically in ALE and FTL files? If the number of lines in small (<100) storing the data in a list of lists will be easy to set up.

Second, is the header/column info in the files the same for each type, i.e, an ALE file always contains 7 lines of header and column info? If so, you know that the data your interested in will always start on the same line. If not, is there something that consistently comes before the data your interested in? If so, search that data and then locate the data your interested from there.

In case your not familiar with the concept of a list of lists, it works something like this:
The Main list contains one or more items. Each of these items is also a list. The items in each of these lists, in this case, represents one line of data from the ALE (or FTL) file. Each item is the data for each column on the line.

Example: we’ll call a varable ALEList contains only the “data” portion of the file
– ALEList contains 10 items (each of these items is a list)
– item 4 of ALEList contains the columnar data for line 4 of the ALE file
– item 3 of (item 4 of ALEList) contains the data for the 3rd column of the 4th line of the data. In this case: “001”

Below represents how item 4 of ALElist might look.
{“23AA-5A”, “VA1A2”, “001”, “24”, “01:02:40:10”, “01:03:52:05”, “00:01:11:25”, “A001”, “08/17/04”, “08:20:11:28”, “001”, “23AA”, “5A”, “EH536453-4421+01”, “EH536453-4528+13”, “AA”, “01:02:40:08”}

Hope this helps,
Brad Bumgarner, CTA

General · July 18, 2005, 10:19pm

An ALE and FTL file will typically have been 70 to a hundred 130 lines.

The ALE header is usually the same, yes. And the word Data comes right before the first line of important details.

That being said, the columns of an ALE sometimes change. For example, the TC24 column is sometimes there, sometimes not. In some regards I think the FTL file might be easier to parse in the end.

A.

General · July 19, 2005, 7:05am

OK, so I think I figured out how to skip the header info on the ALE file. However, I think I managed to mess up the script trying to pull out the data I want.

This is what I have so far.

tell application “Finder”

set these_items to (choose file with prompt "Pick ALE file to use:") as list


open these_items

set this_data to read (item 1 of these_items) using delimiter return
set mydata to {}
repeat with i from 1 to the count of this_data
	
	set the end of mydata to items 13 thru (count of this_data) of this_data
end repeat
my ParseFurther(mydata)

end tell

on ParseFurther(mydata)
set AppleScript’s text item delimiters to tab
set theInfo to {}
repeat with t from 1 to the count of mydata
set theName to (item 1 of mydata)
set theINPOINT to (item 7 of mydata)
set theOUTPOINT to (item 8 of mydata)
set the end of theInfo to {theName, theINPOINT, theOUTPOINT}
end repeat
end ParseFurther

The result of the script so far is this:

{{"
PUNCH-1 VA1A2 001 24 01:00:00:00 01:00:13:05 00:00:13:05 A001 08/17/04 08:08:32:17 001 PUNCH 1 DAY ONE EH536453-3955+00 EH536453-3974+12 AA 01:00:00:00", "
23AA-3A VA1A2 001 24 01:00:13:00 01:01:25:00 00:01:12:00 A001 08/17/04 08:14:19:25 001 23AA 3A EH536453-4197+06 EH536453-4305+06 AA 01:00:13:00", "
23AA-4A VA1A2 001 24 01:01:25:10 01:02:40:05 00:01:14:25 A001 08/17/04 08:17:25:28 001 23AA 4A EH536453-4306+11 EH536453-4418+15 AA 01:01:25:08", "
23AA-5A VA1A2 001 24 01:02:40:10 01:03:52:05 00:01:11:25 A001 08/17/04 08:20:11:28 001 23AA 5A EH536453-4421+01 EH536453-4528+13 AA 01:02:40:08", "
23AA-7A VA1A2 001 24 01:03:52:20 01:05:06:20 00:01:14:00 A001 08/17/04 08:27:18:27 001 23AA 7A EH536453-4644+11 EH536453-4755+11 AA 01:03:52:16", "
23AA-8A VA1A2 001 24 01:05:07:10 01:06:21:10 00:01:14:00 A001 08/17/04 08:29:55:14 001 23AA 8A EH536453-4758+11 EH536453-4869+11 AA 01:05:07:08", "
PUNCH-1A VA1A2 001 24 01:06:22:15 01:06:25:05 00:00:02:20 A002 08/17/04 08:31:10:19 001 PUNCH 1A EH536453-4960+00 EH536453-4964+00 AA 01:06:22:12", "
23AA-10A VA1A2 001 24 01:06:25:10 01:07:38:05 00:01:12:25 A002 08/17/04 08:34:18:08 001 23AA 10A EH536453-4977+11 EH536453-5086+15 AA 01:06:25:08", "
23AB-2A VA1A2 001 24 01:07:38:15 01:08:03:05 00:00:24:20 A002 08/17/04 08:55:26:08 001 23AB 2A EH536453-5129+14 EH536453-5166+14 AA 01:07:38:12", "
23AB-3A VA1A2 001 24 01:08:04:10 01:08:30:15 00:00:26:05 A002 08/17/04 08:56:35:03 001 23AB 3A EH536453-5168+11 EH536453-5207+15 AA 01:08:04:08", "
23AB-4A VA1A2 001 24 01:08:31:10 01:08:59:15 00:00:28:05 A002 08/17/04 08:57:50:24 001 23AB 4A EH536453-5209+09 EH536453-5251+13 AA 01:08:31:08", "
23AB-5A VA1A2 001 24 01:09:00:10 01:09:30:20 00:00:30:10 A002 08/17/04 08:59:51:28 001 23AB 5A EH536453-5253+14 EH536453-5299+06 AA 01:09:00:08", "
23AC-4A VA1A2 001 24 01:09:31:05 01:10:01:25 00:00:30:20 A002 08/17/04 09:40:15:27 001 23AC 4A EH536453-5453+02 EH536453-5499+02 AA 01:09:31:04", "
23AC-5A VA1A2 001 24 01:10:02:25 01:10:31:15 00:00:28:20 A002 08/17/04 09:41:32:05 001 23AC 5A EH536453-5503+06 EH536453-5546+06 AA 01:10:02:20", "
PUNCH-1A VA1A2 001 24 01:10:32:05 01:10:35:15 00:00:03:10 A003 08/17/04 10:00:31:14 001 PUNCH 1A EH536456-6979+00 EH536456-6984+00 AA 01:10:32:04", "
23AD-5A VA1A2 001 24 01:10:35:25 01:11:15:00 00:00:39:05 A003 08/17/04 10:12:48:08 001 23AD 5A EH536456-6980+13 EH536456-7039+09 AA 01:10:35:20", "
23AD-6A VA1A2 001 24 01:11:15:10 01:11:58:10 00:00:43:00 A003 08/17/04 10:14:44:19 001 23AD 6A EH536456-7047+02 EH536456-7111+10 AA 01:11:15:08", "
23AD-7A VA1A2 001 24 01:11:58:25 01:12:44:00 00:00:45:05 A003 08/17/04 10:16:48:23 001 23AD 7A EH536456-7115+08 EH536456-7183+04 AA 01:11:58:20", "
23AE-2A VA1A2 001 24 01:12:44:05 01:13:23:15 00:00:39:10 A003 08/17/04 10:37:11:07 001 23AE 2A EH536456-7238+12 EH536456-7297+12 AA 01:12:44:04", "
23AE-3A VA1A2 001 24 01:13:23:25 01:13:59:05 00:00:35:10 A003 08/17/04 10:38:32:25 001 23AE 3A EH536456-7299+02 EH536456-7352+02 AA 01:13:23:20", "
23AE-6A VA1A2 001 24 01:13:59:15 01:14:35:00 00:00:35:15 A003 08/17/04 10:43:14:29 001 23AE 6A EH536456-7492+10 EH536456-7545+14 AA 01:13:59:12", "
23AF-4A VA1A2 001 24 01:14:35:15 01:15:13:10 00:00:37:25 A003 08/17/04 11:01:04:21 001 23AF 4A EH536456-7708+05 EH536456-7765+01 AA 01:14:35:12", "
23AF-6A VA1A2 001 24 01:15:13:25 01:15:48:20 00:00:34:25 A003 08/17/04 11:02:55:12 001 23AF 6A EH536456-7816+04 EH536456-7868+08 AA 01:15:13:20", "
23AF-7A VA1A2 001 24 01:15:49:05 01:16:21:15 00:00:32:10 A003 08/17/04 11:04:04:14 001 23AF 7A EH536456-7868+11 EH536456-7917+03 AA 01:15:49:04", "
PUNCH-1A VA1A2 001 24 01:16:22:00 01:16:28:25 00:00:06:25 A004 08/17/04 11:04:38:07 001 PUNCH 1A EH536452-7991+00 EH536452-8001+04 AA 01:16:22:00", "
23AF-8A VA1A2 001 24 01:16:29:05 01:17:04:15 00:00:35:10 A004 08/17/04 11:06:30:09 001 23AF 8A EH536452-7992+15 EH536452-8045+15 AA 01:16:29:04", "
23AG-2A VA1A2 001 24 01:17:05:05 01:17:32:05 00:00:27:00 A004 08/17/04 11:34:15:29 001 23AG 2A EH536452-8086+11 EH536452-8127+03 AA 01:17:05:04", "
23AG-3A VA1A2 001 24 01:17:32:10 01:18:00:05 00:00:27:25 A004 08/17/04 11:35:55:13 001 23AG 3A EH536452-8132+14 EH536452-8174+10 AA 01:17:32:08", "
23AG-4A VA1A2 001 24 01:18:00:15 01:18:29:05 00:00:28:20 A004 08/17/04 11:38:39:23 001 23AG 4A EH536452-8175+15 EH536452-8218+15 AA 01:18:00:12", "
23AG-5A VA1A2 001 24 01:18:29:20 01:18:59:00 00:00:29:10 A004 08/17/04 11:42:57:26 001 23AG 5A EH536452-8220+10 EH536452-8264+10 AA 01:18:29:16", "
65AA-1A VA1A2 001 24 01:18:59:00 01:19:25:25 00:00:26:25 A004 08/17/04 12:21:34:13 001 65AA 1A EH536452-8265+10 EH536452-8305+14 AA 01:18:59:00", "
65AA-2A VA1A2 001 24 01:19:25:25 01:19:47:25 00:00:22:00 A004 08/17/04 12:23:14:28 001 65AA 2A EH536452-8306+12 EH536452-8339+12 AA 01:19:25:20", "
65AA-3A VA1A2 001 24 01:19:47:25 01:20:14:05 00:00:26:10 A004 08/17/04 12:24:56:10 001 65AA 3A EH536452-8343+07 EH536452-8382+15 AA 01:19:47:20", "
65AA-4A VA1A2 001 24 01:20:14:10 01:20:38:05 00:00:23:25 A004 08/17/04 12:26:18:08 001 65AA 4A EH536452-8384+00 EH536452-8419+12 AA 01:20:14:08", "
23AH-2A VA1A2 001 24 01:20:38:10 01:21:07:10 00:00:29:00 A004 08/17/04 14:06:02:11 001 23AH 2A EH536452-8449+07 EH536452-8492+15 AA 01:20:38:08", "
23AH-3A VA1A2 001 24 01:21:07:20 01:21:37:00 00:00:29:10 A004 08/17/04 14:07:51:27 001 23AH 3A EH536452-8499+08 EH536452-8543+08 AA 01:21:07:16", "
23AH-4A VA1A2 001 24 01:21:36:25 01:22:03:10 00:00:26:15 A004 08/17/04 14:08:51:09 001 23AH 4A EH536452-8547+04 EH536452-8587+00 AA 01:21:36:20", "
23AH-5A VA1A2 001 24 01:22:04:05 01:22:31:20 00:00:27:15 A004 08/17/04 14:10:39:08 001 23AH 5A EH536452-8589+02 EH536452-8630+06 AA 01:22:04:04", "
PUNCH-1A VA1A2 001 24 01:22:32:00 01:22:40:20 00:00:08:20 A005 08/17/04 14:11:08:05 002 PUNCH 1A EH536452-6979+00 EH536452-6992+00 AA 01:22:32:00", "
6BA-1A VA1A2 001 24 01:22:41:00 01:23:13:00 00:00:32:00 A005 08/17/04 15:06:13:13 002 6BA 1A VFX EH536452-6994+01 EH536452-7042+01 AA 01:22:41:00", "
6BA-3A VA1A2 001 24 01:23:13:15 01:23:42:00 00:00:28:15 A005 08/17/04 15:11:04:19 002 6BA 3A VFX EH536452-7090+09 EH536452-7133+05 AA 01:23:13:12", "
6BA-4A VA1A2 001 24 01:23:42:00 01:24:13:00 00:00:31:00 A005 08/17/04 15:12:46:20 002 6BA 4A VFX EH536452-7134+04 EH536452-7180+12 AA 01:23:42:00", "
6BA-5A VA1A2 001 24 01:24:13:00 01:24:43:00 00:00:30:00 A005 08/17/04 15:14:09:25 002 6BA 5A VFX EH536452-7181+11 EH536452-7226+11 AA 01:24:13:00", "
6BA-6A VA1A2 001 24 01:24:43:15 01:25:13:20 00:00:30:05 A005 08/17/04 15:15:36:18 002 6BA 6A VFX EH536452-7226+03 EH536452-7271+07 AA 01:24:43:12", "
6BB-3A VA1A2 001 24 01:25:14:05 01:26:11:15 00:00:57:10 A005 08/17/04 15:51:12:10 002 6BB 3A EH536452-7459+11 EH536452-7545+11 AA 01:25:14:04", "
6BB-5A VA1A2 001 24 01:26:12:00 01:27:15:05 00:01:03:05 A005 08/17/04 15:56:02:26 002 6BB 5A EH536452-7638+10 EH536452-7733+06 AA 01:26:12:00", "
6BB-6A VA1A2 001 24 01:27:15:05 01:28:12:10 00:00:57:05 A005 08/17/04 16:00:17:19 002 6BB 6A EH536452-7734+03 EH536452-7819+15 AA 01:27:15:04", "
PUNCH-1A VA1A2 001 24 01:28:12:20 01:28:15:25 00:00:03:05 A006 08/17/04 16:01:16:02 002 PUNCH 1A EH536455-6980+00 EH536455-6984+12 AA 01:28:12:16", "
6BC-2A VA1A2 001 24 01:28:15:20 01:29:08:00 00:00:52:10 A006 08/17/04 16:08:46:26 002 6BC 2A EH536455-7067+12 EH536455-7146+04 AA 01:28:15:16", "
6BC-3A VA1A2 001 24 01:29:08:05 01:30:03:10 00:00:55:05 A006 08/17/04 16:10:30:03 002 6BC 3A EH536455-7150+06 EH536455-7233+02 AA 01:29:08:04", "
6BC-4A VA1A2 001 24 01:30:03:25 01:31:02:00 00:00:58:05 A006 08/17/04 16:12:23:08 002 6BC 4A EH536455-7233+01 EH536455-7320+05 AA 01:30:03:20", "
6BD-1A VA1A2 001 24 01:31:02:10 01:32:00:05 00:00:57:25 A006 08/17/04 16:29:23:03 002 6BD 1A EH536455-7324+09 EH536455-7411+05 AA 01:31:02:08", "
6BD-2A VA1A2 001 24 01:32:01:05 01:32:57:15 00:00:56:10 A006 08/17/04 16:31:09:11 002 6BD 2A EH536455-7415+01 EH536455-7499+09 AA 01:32:01:04", "
6BE-2A VA1A2 001 24 01:32:58:10 01:33:35:00 00:00:36:20 A006 08/17/04 17:03:48:23 002 6BE 2A VFX EH536455-7524+00 EH536455-7579+00 AA 01:32:58:08", "
6BE-3A V 001 24 01:33:35:25 01:34:23:05 00:00:47:10 A006 08/17/04 MOS 6BE 3A VFX EH536455-7580+09 EH536455-7651+09 AA 01:33:35:20", "
5A-3A VA1A2 001 24 01:34:23:15 01:34:46:20 00:00:23:05 A006 08/17/04 17:51:10:11 002 5A 3A EH536455-7734+09 EH536455-7769+05 AA 01:34:23:12", "
5A-4A VA1A2 001 24 01:34:46:20 01:35:10:10 00:00:23:20 A006 08/17/04 17:52:02:10 002 5A 4A EH536455-7770+02 EH536455-7805+10 AA 01:34:46:16", "
5A-5A VA1A2 001 24 01:35:10:25 01:35:34:10 00:00:23:15 A006 08/17/04 17:53:37:00 002 5A 5A EH536455-7805+00 EH536455-7840+04 AA 01:35:10:20", "
PUNCH-1A VA1A2 001 24 01:35:35:05 01:35:39:05 00:00:04:00 A007 08/17/04 17:54:02:07 002 PUNCH 1A EH536455-9000+00 EH536455-9006+00 AA 01:35:35:04", "
5B-1A VA1A2 001 24 01:35:39:10 01:35:54:10 00:00:15:00 A007 08/17/04 18:12:12:29 002 5B 1A EH536455-9000+10 EH536455-9023+02 AA 01:35:39:08", "
5B-2A VA1A2 001 24 01:35:54:20 01:36:16:00 00:00:21:10 A007 08/17/04 18:12:42:18 002 5B 2A EH536455-9025+13 EH536455-9057+13 AA 01:35:54:16", "
PUNCH-1B VA1A2 001 24 01:36:16:00 01:36:19:20 00:00:03:20 B001 08/17/04 18:13:04:26 002 PUNCH 1B EH536456-9003+00 EH536456-9008+08 AA 01:36:16:00", "
5-1B VA1A2 001 24 01:36:19:15 01:36:36:15 00:00:17:00 B001 08/17/04 17:29:34:22 002 5 1B EH536456-9010+08 EH536456-9036+00 AA 01:36:19:12", "
5-2B VA1A2 001 24 01:36:36:25 01:36:56:10 00:00:19:15 B001 08/17/04 17:32:30:20 002 5 2B EH536456-9038+13 EH536456-9068+01 AA 01:36:36:20", "
5A-3B VA1A2 001 24 01:36:56:15 01:37:18:00 00:00:21:15 B001 08/17/04 17:51:11:26 002 5A 3B EH536456-9136+03 EH536456-9168+07 AA 01:36:56:12", "
5A-4B VA1A2 001 24 01:37:17:25 01:37:37:15 00:00:19:20 B001 08/17/04 17:52:02:18 002 5A 4B EH536456-9169+02 EH536456-9198+10 AA 01:37:17:20", "
5A-5B VA1A2 001 24 01:37:38:10 01:38:03:10 00:00:25:00 B001 08/17/04 17:53:32:28 002 5A 5B EH536456-9200+10 EH536456-9238+02 AA 01:37:38:08", "
END-1B VA1A2 001 24 01:38:03:10 01:38:28:05 00:00:24:25 B001 08/17/04 17:53:59:00 002 END 1B EH536456-9238+14 EH536456-9242+12 AA 01:38:03:08", "
“}, {”
PUNCH-1 VA1A2 001 24 01:00:00:00 01:00:13:05 00:00:13:05 A001 08/17/04 08:08:32:17 001 PUNCH 1 DAY ONE EH536453-3955+00 EH536453-3974+12 AA 01:00:00:00", "
23AA-3A VA1A2 001 24 01:00:13:00 01:01:25:00 00:01:12:00 A001 08/17/04 08:14:19:25 001 23AA 3A EH536453-4197+06 EH536453-4305+06 AA 01:00:13:00", "
23AA-4A VA1A2 001 24 01:01:25:10 01:02:40:05 00:01:14:25 A001 08/17/04 08:17:25:28 001 23AA 4A EH536453-4306+11 EH536453-4418+15 AA 01:01:25:08", "
23AA-5A VA1A2 001 24 01:02:40:10 01:03:52:05 00:01:11:25 A001 08/17/04 08:20:11:28 001 23AA 5A EH536453-4421+01 EH536453-4528+13 AA 01:02:40:08", "
23AA-7A VA1A2 001 24 01:03:52:20 01:05:06:20 00:01:14:00 A001 08/17/04 08:27:18:27 001 23AA 7A EH536453-4644+11 EH536453-4755+11 AA 01:03:52:16", "
23AA-8A VA1A2 001 24 01:05:07:10 01:06:21:10 00:01:14:00 A001 08/17/04 08:29:55:14 001 23AA 8A EH536453-4758+11 EH536453-4869+11 AA 01:05:07:08", "
PUNCH-1A VA1A2 001 24 01:06:22:15 01:06:25:05 00:00:02:20 A002 08/17/04 08:31:10:19 001 PUNCH 1A EH536453-4960+00 EH536453-4964+00 AA 01:06:22:12", "
23AA-10A VA1A2 001 24 01:06:25:10 01:07:38:05 00:01:12:25 A002 08/17/04 08:34:18:08 001 23AA 10A EH536453-4977+11 EH536453-5086+15 AA 01:06:25:08", "
23AB-2A VA1A2 001 24 01:07:38:15 01:08:03:05 00:00:24:20 A002 08/17/04 08:55:26:08 001 23AB 2A EH536453-5129+14 EH536453-5166+14 AA 01:07:38:12", "
23AB-3A VA1A2 001 24 01:08:04:10 01:08:30:15 00:00:26:05 A002 08/17/04 08:56:35:03 001 23AB 3A EH536453-5168+11 EH536453-5207+15 AA 01:08:04:08", "
23AB-4A VA1A2 001 24 01:08:31:10 01:08:59:15 00:00:28:05 A002 08/17/04 08:57:50:24 001 23AB 4A EH536453-5209+09 EH536453-5251+13 AA 01:08:31:08", "
23AB-5A VA1A2 001 24 01:09:00:10 01:09:30:20 00:00:30:10 A002 08/17/04 08:59:51:28 001 23AB 5A EH536453-5253+14 EH536453-5299+06 AA 01:09:00:08", "
23AC-4A VA1A2 001 24 01:09:31:05 01:10:01:25 00:00:30:20 A002 08/17/04 09:40:15:27 001 23AC 4A EH536453-5453+02 EH536453-5499+02 AA 01:09:31:04", "
23AC-5A VA1A2 001 24 01:10:02:25 01:10:31:15 00:00:28:20 A002 08/17/04 09:41:32:05 001 23AC 5A EH536453-5503+06 EH536453-5546+06 AA 01:10:02:20", "
PUNCH-1A VA1A2 001 24 01:10:32:05 01:10:35:15 00:00:03:10 A003 08/17/04 10:00:31:14 001 PUNCH 1A EH536456-6979+00 EH536456-6984+00 AA 01:10:32:04", "
23AD-5A VA1A2 001 24 01:10:35:25 01:11:15:00 00:00:39:05 A003 08/17/04 10:12:48:08 001 23AD 5A EH536456-6980+13 EH536456-7039+09 AA 01:10:35:20", "
23AD-6A VA1A2 001 24 01:11:15:10 01:11:58:10 00:00:43:00 A003 08/17/04 10:14:44:19 001 23AD 6A EH536456-7047+02 EH536456-7111+10 AA 01:11:15:08", "
23AD-7A VA1A2 001 24 01:11:58:25 01:12:44:00 00:00:45:05 A003 08/17/04 10:16:48:23 001 23AD 7A EH536456-7115+08 EH536456-7183+04 AA 01:11:58:20", "
23AE-2A VA1A2 001 24 01:12:44:05 01:13:23:15 00:00:39:10 A003 08/17/04 10:37:11:07 001 23AE 2A EH536456-7238+12 EH536456-7297+12 AA 01:12:44:04", "
23AE-3A VA1A2 001 24 01:13:23:25 01:13:59:05 00:00:35:10 A003 08/17/04 10:38:32:25 001 23AE 3A EH536456-7299+02 EH536456-7352+02 AA 01:13:23:20", "
23AE-6A VA1A2 001 24 01:13:59:15 01:14:35:00 00:00:35:15 A003 08/17/04 10:43:14:29 001 23AE 6A EH536456-7492+10 EH536456-7545+14 AA 01:13:59:12", "
23AF-4A VA1A2 001 24 01:14:35:15 01:15:13:10 00:00:37:25 A003 08/17/04 11:01:04:21 001 23AF 4A EH536456-7708+05 EH536456-7765+01 AA 01:14:35:12", "
23AF-6A VA1A2 001 24 01:15:13:25 01:15:48:20 00:00:34:25 A003 08/17/04 11:02:55:12 001 23AF 6A EH536456-7816+04 EH536456-7868+08 AA 01:15:13:20", "
23AF-7A VA1A2 001 24 01:15:49:05 01:16:21:15 00:00:32:10 A003 08/17/04 11:04:04:14 001 23AF 7A EH536456-7868+11 EH536456-7917+03 AA 01:15:49:04", "
PUNCH-1A VA1A2 001 24 01:16:22:00 01:16:28:25 00:00:06:25 A004 08/17/04 11:04:38:07 001 PUNCH 1A EH536452-7991+00 EH536452-8001+04 AA 01:16:22:00", "
23AF-8A VA1A2 001 24 01:16:29:05 01:17:04:15 00:00:35:10 A004 08/17/04 11:06:30:09 001 23AF 8A EH536452-7992+15 EH536452-8045+15 AA 01:16:29:04", "
23AG-2A VA1A2 001 24 01:17:05:05 01:17:32:05 00:00:27:00 A004 08/17/04 11:34:15:29 001 23AG 2A EH536452-8086+11 EH536452-8127+03 AA 01:17:05:04", "
23AG-3A VA1A2 001 24 01:17:32:10 01:18:00:05 00:00:27:25 A004 08/17/04 11:35:55:13 001 23AG 3A EH536452-8132+14 EH536452-8174+10 AA 01:17:32:08", "
23AG-4A VA1A2 001 24 01:18:00:15 01:18:29:05 00:00:28:20 A004 08/17/04 11:38:39:23 001 23AG 4A EH536452-8175+15 EH536452-8218+15 AA 01:18:00:12", "
23AG-5A VA1A2 001 24 01:18:29:20 01:18:59:00 00:00:29:10 A004 08/17/04 11:42:57:26 001 23AG 5A EH536452-8220+10 EH536452-8264+10 AA 01:18:29:16", "
65AA-1A VA1A2 001 24 01:18:59:00 01:19:25:25 00:00:26:25 A004 08/17/04 12:21:34:13 001 65AA 1A EH536452-8265+10 EH536452-8305+14 AA 01:18:59:00", "
65AA-2A VA1A2 001 24 01:19:25:25 01:19:47:25 00:00:22:00 A004 08/17/04 12:23:14:28 001 65AA 2A EH536452-8306+12 EH536452-8339+12 AA 01:19:25:20", "
65AA-3A VA1A2 001 24 01:19:47:25 01:20:14:05 00:00:26:10 A004 08/17/04 12:24:56:10 001 65AA 3A EH536452-8343+07 EH536452-8382+15 AA 01:19:47:20", "
65AA-4A VA1A2 001 24 01:20:14:10 01:20:38:05 00:00:23:25 A004 08/17/04 12:26:18:08 001 65AA 4A EH536452-8384+00 EH536452-8419+12 AA 01:20:14:08", "
23AH-2A VA1A2 001 24 01:20:38:10 01:21:07:10 00:00:29:00 A004 08/17/04 14:06:02:11 001 23AH 2A EH536452-8449+07 EH536452-8492+15 AA 01:20:38:08", "
23AH-3A VA1A2 001 24 01:21:07:20 01:21:37:00 00:00:29:10 A004 08/17/04 14:07:51:27 001 23AH 3A EH536452-8499+08 EH536452-8543+08 AA 01:21:07:16", "
23AH-4A VA1A2 001 24 01:21:36:25 01:22:03:10 00:00:26:15 A004 08/17/04 14:08:51:09 001 23AH 4A EH536452-8547+04 EH536452-8587+00 AA 01:21:36:20", "
23AH-5A VA1A2 001 24 01:22:04:05 01:22:31:20 00:00:27:15 A004 08/17/04 14:10:39:08 001 23AH 5A EH536452-8589+02 EH536452-8630+06 AA 01:22:04:04", "
PUNCH-1A VA1A2 001 24 01:22:32:00 01:22:40:20 00:00:08:20 A005 08/17/04 14:11:08:05 002 PUNCH 1A EH536452-6979+00 EH536452-6992+00 AA 01:22:32:00", "
6BA-1A VA1A2 001 24 01:22:41:00 01:23:13:00 00:00:32:00 A005 08/17/04 15:06:13:13 002 6BA 1A VFX EH536452-6994+01 EH536452-7042+01 AA 01:22:41:00", "
6BA-3A VA1A2 001 24 01:23:13:15 01:23:42:00 00:00:28:15 A005 08/17/04 15:11:04:19 002 6BA 3A VFX EH536452-7090+09 EH536452-7133+05 AA 01:23:13:12", "
6BA-4A VA1A2 001 24 01:23:42:00 01:24:13:00 00:00:31:00 A005 08/17/04 15:12:46:20 002 6BA 4A VFX EH536452-7134+04 EH536452-7180+12 AA 01:23:42:00", "
6BA-5A VA1A2 001 24 01:24:13:00 01:24:43:00 00:00:30:00 A005 08/17/04 15:14:09:25 002 6BA 5A VFX EH536452-7181+11 EH536452-7226+11 AA 01:24:13:00", "
6BA-6A VA1A2 001 24 01:24:43:15 01:25:13:20 00:00:30:05 A005 08/17/04 15:15:36:18 002 6BA 6A VFX EH536452-7226+03 EH536452-7271+07 AA 01:24:43:12", "
6BB-3A VA1A2 001 24 01:25:14:05 01:26:11:15 00:00:57:10 A005 08/17/04 15:51:12:10 002 6BB 3A EH536452-7459+11 EH536452-7545+11 AA 01:25:14:04", "
6BB-5A VA1A2 001 24 01:26:12:00 01:27:15:05 00:01:03:05 A005 08/17/04 15:56:02:26 002 6BB 5A EH536452-7638+10 EH536452-7733+06 AA 01:26:12:00", "
6BB-6A VA1A2 001 24 01:27:15:05 01:28:12:10 00:00:57:05 A005 08/17/04 16:00:17:19 002 6BB 6A EH536452-7734+03 EH536452-7819+15 AA 01:27:15:04", "
PUNCH-1A VA1A2 001 24 01:28:12:20 01:28:15:25 00:00:03:05 A006 08/17/04 16:01:16:02 002 PUNCH 1A EH536455-6980+00 EH536455-6984+12 AA 01:28:12:16", "
6BC-2A VA1A2 001 24 01:28:15:20 01:29:08:00 00:00:52:10 A006 08/17/04 16:08:46:26 002 6BC 2A EH536455-7067+12 EH536455-7146+04 AA 01:28:15:16", "
6BC-3A VA1A2 001 24 01:29:08:05 01:30:03:10 00:00:55:05 A006 08/17/04 16:10:30:03 002 6BC 3A EH536455-7150+06 EH536455-7233+02 AA 01:29:08:04", "
6BC-4A VA1A2 001 24 01:30:03:25 01:31:02:00 00:00:58:05 A006 08/17/04 16:12:23:08 002 6BC 4A EH536455-7233+01 EH536455-7320+05 AA 01:30:03:20", "
6BD-1A VA1A2 001 24 01:31:02:10 01:32:00:05 00:00:57:25 A006 08/17/04 16:29:23:03 002 6BD 1A EH536455-7324+09 EH536455-7411+05 AA 01:31:02:08", "
6BD-2A VA1A2 001 24 01:32:01:05 01:32:57:15 00:00:56:10 A006 08/17/04 16:31:09:11 002 6BD 2A EH536455-7415+01 EH536455-7499+09 AA 01:32:01:04", "
6BE-2A VA1A2 001 24 01:32:58:10 01:33:35:00 00:00:36:20 A006 08/17/04 17:03:48:23 002 6BE 2A VFX EH536455-7524+00 EH536455-7579+00 AA 01:32:58:08", "
6BE-3A V 001 24 01:33:35:25 01:34:23:05 00:00:47:10 A006 08/17/04 MOS 6BE 3A VFX EH536455-7580+09 EH536455-7651+09 AA 01:33:35:20", "
5A-3A VA1A2 001 24 01:34:23:15 01:34:46:20 00:00:23:05 A006 08/17/04 17:51:10:11 002 5A 3A EH536455-7734+09 EH536455-7769+05 AA 01:34:23:12", "
5A-4A VA1A2 001 24 01:34:46:20 01:35:10:10 00:00:23:20 A006 08/17/04 17:52:02:10 002 5A 4A EH536455-7770+02 EH536455-7805+10 AA 01:34:46:16", "
5A-5A VA1A2 001 24 01:35:10:25 01:35:34:10 00:00:23:15 A006 08/17/04 17:53:37:00 002 5A 5A EH536455-7805+00 EH536455-7840+04 AA 01:35:10:20", "
PUNCH-1A VA1A2 001 24 01:35:35:05 01:35:39:05 00:00:04:00 A007 08/17/04 17:54:02:07 002 PUNCH 1A EH536455-9000+00 EH536455-9006+00 AA 01:35:35:04", "
5B-1A VA1A2 001 24 01:35:39:10 01:35:54:10 00:00:15:00 A007 08/17/04 18:12:12:29 002 5B 1A EH536455-9000+10 EH536455-9023+02 AA 01:35:39:08", "
5B-2A VA1A2 001 24 01:35:54:20 01:36:16:00 00:00:21:10 A007 08/17/04 18:12:42:18 002 5B 2A EH536455-9025+13 EH536455-9057+13 AA 01:35:54:16", "
PUNCH-1B VA1A2 001 24 01:36:16:00 01:36:19:20 00:00:03:20 B001 08/17/04 18:13:04:26 002 PUNCH 1B EH536456-9003+00 EH536456-9008+08 AA 01:36:16:00", "
5-1B VA1A2 001 24 01:36:19:15 01:36:36:15 00:00:17:00 B001 08/17/04 17:29:34:22 002 5 1B EH536456-9010+08 EH536456-9036+00 AA 01:36:19:12", "
5-2B VA1A2 001 24 01:36:36:25 01:36:56:10 00:00:19:15 B001 08/17/04 17:32:30:20 002 5 2B EH536456-9038+13 EH536456-9068+01 AA 01:36:36:20", "
5A-3B VA1A2 001 24 01:36:56:15 01:37:18:00 00:00:21:15 B001 08/17/04 17:51:11:26 002 5A 3B EH536456-9136+03 EH536456-9168+07 AA 01:36:56:12", "
5A-4B VA1A2 001 24 01:37:17:25 01:37:37:15 00:00:19:20 B001 08/17/04 17:52:02:18 002 5A 4B EH536456-9169+02 EH536456-9198+10 AA 01:37:17:20", "
5A-5B VA1A2 001 24 01:37:38:10 01:38:03:10 00:00:25:00 B001 08/17/04 17:53:32:28 002 5A 5B EH536456-9200+10 EH536456-9238+02 AA 01:37:38:08", "
END-1B VA1A2 001 24 01:38:03:10 01:38:28:05 00:00:24:25 B001 08/17/04 17:53:59:00 002 END 1B EH536456-9238+14 EH536456-9242+12 AA 01:38:03:08", "
“}, {”
PUNCH-1 VA1A2 001 24 01:00:00:00 01:00:13:05 00:00:13:05 A001 08/17/04 08:08:32:17 001 PUNCH 1 DAY ONE EH536453-3955+00 EH536453-3974+12 AA 01:00:00:00", "
23AA-3A VA1A2 001 24 01:00:13:00 01:01:25:00 00:01:12:00 A001 08/17/04 08:14:19:25 001 23AA 3A EH536453-4197+06 EH536453-4305+06 AA 01:00:13:00", "
23AA-4A VA1A2 001 24 01:01:25:10 01:02:40:05 00:01:14:25 A001 08/17/04 08:17:25:28 001 23AA 4A EH536453-4306+11 EH536453-4418+15 AA 01:01:25:08", "
23AA-5A VA1A2 001 24 01:02:40:10 01:03:52:05 00:01:11:25 A001 08/17/04 08:20:11:28 001 23AA 5A EH536453-4421+01 EH536453-4528+13 AA 01:02:40:08", "
23AA-7A VA1A2 001 24 01:03:52:20 01:05:06:20 00:01:14:00 A001 08/17/04 08:27:18:27 001 23AA 7A EH536453-4644+11 EH536453-4755+11 AA 01:03:52:16", "
23AA-8A VA1A2 001 24 01:05:07:10 01:06:21:10 00:01:14:00 A001 08/17/04 08:29:55:14 001 23AA 8A EH536453-4758+11 EH536453-4869+11 AA 01:05:07:08", "
PUNCH-1A VA1A2 001 24 01:06:22:15 01:06:25:05 00:00:02:20 A002 08/17/04 08:31:10:19 001 PUNCH 1A EH536453-4960+00 EH536453-4964+00 AA 01:06:22:12", "
23AA-10A VA1A2 001 24 01:06:25:10 01:07:38:05 00:01:12:25 A002 08/17/04 08:34:18:08 001 23AA 10A EH536453-4977+11 EH536453-5086+15 AA 01:06:25:08", "
23AB-2A VA1A2 001 24 01:07:38:15 01:08:03:05 00:00:24:20 A002 08/17/04 08:55:26:08 001 23AB 2A EH536453-5129+14 EH536453-5166+14 AA 01:07:38:12", "
23AB-3A VA1A2 001 24 01:08:04:10 01:08:30:15 00:00:26:05 A002 08/17/04 08:56:35:03 001 23AB 3A EH536453-5168+11 EH536453-5207+15 AA 01:08:04:08", "
23AB-4A VA1A2 001 24 01:08:31:10 01:08:59:15 00:00:28:05 A002 08/17/04 08:57:50:24 001 23AB 4A EH536453-5209+09 EH536453-5251+13 AA 01:08:31:08", "
23AB-5A VA1A2 001 24 01:09:00:10 01:09:30:20 00:00:30:10 A002 08/17/04 08:59:51:28 001 23AB 5A EH536453-5253+14 EH536453-5299+06 AA 01:09:00:08", "
23AC-4A VA1A2 001 24 01:09:31:05 01:10:01:25 00:00:30:20 A002 08/17/04 09:40:15:27 001 23AC 4A EH536453-5453+02 EH536453-5499+02 AA 01:09:31:04", "
23AC-5A VA1A2 001 24 01:10:02:25 01:10:31:15 00:00:28:20 A002 08/17/04 09:41:32:05 001 23AC 5A EH536453-5503+06 EH536453-5546+06 AA 01:10:02:20", "
PUNCH-1A VA1A2 001 24 01:10:32:05 01:10:35:15 00:00:03:10 A003 08/17/04 10:00:31:14 001 PUNCH 1A EH536456-6979+00 EH536456-6984+00 AA 01:10:32:04", "
23AD-5A VA1A2 001 24 01:10:35:25 01:11:15:00 00:00:39:05 A003 08/17/04 10:12:48:08 001 23AD 5A EH536456-6980+13 EH536456-7039+09 AA 01:10:35:20", "
23AD-6A VA1A2 001 24 01:11:15:10 01:11:58:10 00:00:43:00 A003 08/17/04 10:14:44:19 001 23AD 6A EH536456-7047+02 EH536456-7111+10 AA 01:11:15:08", "
23AD-7A VA1A2 001 24 01:11:58:25 01:12:44:00 00:00:45:05 A003 08/17/04 10:16:48:23 001 23AD 7A EH536456-7115+08 EH536456-7183+04 AA 01:11:58:20", "
23AE-2A VA1A2 001 24 01:12:44:05 01:13:23:15 00:00:39:10 A003 08/17/04 10:37:11:07 001 23AE 2A EH536456-7238+12 EH536456-7297+12 AA 01:12:44:04", "
23AE-3A VA1A2 001 24 01:13:23:25 01:13:59:05 00:00:35:10 A003 08/17/04 10:38:32:25 001 23AE 3A EH536456-7299+02 EH536456-7352+02 AA 01:13:23:20", "
23AE-6A VA1A2 001 24 01:13:59:15 01:14:35:00 00:00:35:15 A003 08/17/04 10:43:14:29 001 23AE 6A EH536456-7492+10 EH536456-7545+14 AA 01:13:59:12", "
23AF-4A VA1A2 001 24 01:14:35:15 01:15:13:10 00:00:37:25 A003 08/17/04 11:01:04:21 001 23AF 4A EH536456-7708+05 EH536456-7765+01 AA 01:14:35:12", "
23AF-6A VA1A2 001 24 01:15:13:25 01:15:48:20 00:00:34:25 A003 08/17/04 11:02:55:12 001 23AF 6A EH536456-7816+04 EH536456-7868+08 AA 01:15:13:20", "
23AF-7A VA1A2 001 24 01:15:49:05 01:16:21:15 00:00:32:10 A003 08/17/04 11:04:04:14 001 23AF 7A EH536456-7868+11 EH536456-7917+03 AA 01:15:49:04", "
PUNCH-1A VA1A2 001 24 01:16:22:00 01:16:28:25 00:00:06:25 A004 08/17/04 11:04:38:07 001 PUNCH 1A EH536452-7991+00 EH536452-8001+04 AA 01:16:22:00", "
23AF-8A VA1A2 001 24 01:16:29:05 01:17:04:15 00:00:35:10 A004 08/17/04 11:06:30:09 001 23AF 8A EH536452-7992+15 EH536452-8045+15 AA 01:16:29:04", "
23AG-2A VA1A2 001 24 01:17:05:05 01:17:32:05 00:00:27:00 A004 08/17/04 11:34:15:29 001 23AG 2A EH536452-8086+11 EH536452-8127+03 AA 01:17:05:04", "
23AG-3A VA1A2 001 24 01:17:32:10 01:18:00:05 00:00:27:25 A004 08/17/04 11:35:55:13 001 23AG 3A EH536452-8132+14 EH536452-8174+10 AA 01:17:32:08", "
23AG-4A VA1A2 001 24 01:18:00:15 01:18:29:05 00:00:28:20 A004 08/17/04 11:38:39:23 001 23AG 4A EH536452-8175+15 EH536452-8218+15 AA 01:18:00:12", "
23AG-5A VA1A2 001 24 01:18:29:20 01:18:59:00 00:00:29:10 A004 08/17/04 11:42:57:26 001 23AG 5A EH536452-8220+10 EH536452-8264+10 AA 01:18:29:16", "
65AA-1A VA1A2 001 24 01:18:59:00 01:19:25:25 00:00:26:25 A004 08/17/04 12:21:34:13 001 65AA 1A EH536452-8265+10 EH536452-8305+14 AA 01:18:59:00", "
65AA-2A VA1A2 001 24 01:19:25:25 01:19:47:25 00:00:22:00 A004 08/17/04 12:23:14:28 001 65AA 2A EH536452-8306+12 EH536452-8339+12 AA 01:19:25:20", "
65AA-3A VA1A2 001 24 01:19:47:25 01:20:14:05 00:00:26:10 A004 08/17/04 12:24:56:10 001 65AA 3A EH536452-8343+07 EH536452-8382+15 AA 01:19:47:20", "
65AA-4A VA1A2 001 24 01:20:14:10 01:20:38:05 00:00:23:25 A004 08/17/04 12:26:18:08 001 65AA 4A EH536452-8384+00 EH536452-8419+12 AA 01:20:14:08", "
23AH-2A VA1A2 001 24 01:20:38:10 01:21:07:10 00:00:29:00 A004 08/17/04 14:06:02:11 001 23AH 2A EH536452-8449+07 EH536452-8492+15 AA 01:20:38:08", "
23AH-3A VA1A2 001 24 01:21:07:20 01:21:37:00 00:00:29:10 A004 08/17/04 14:07:51:27 001 23AH 3A EH536452-8499+08 EH536452-8543+08 AA 01:21:07:16", "
23AH-4A VA1A2 001 24 01:21:36:25 01:22:03:10 00:00:26:15 A004 08/17/04 14:08:51:09 001 23AH 4A EH536452-8547+04 EH536452-8587+00 AA 01:21:36:20", "
23AH-5A VA1A2 001 24 01:22:04:05 01:22:31:20 00:00:27:15 A004 08/17/04 14:10:39:08 001 23AH 5A EH536452-8589+02 EH536452-8630+06 AA 01:22:04:04", "
PUNCH-1A VA1A2 001 24 01:22:32:00 01:22:40:20 00:00:08:20 A005 08/17/04 14:11:08:05 002 PUNCH 1A EH536452-6979+00 EH536452-6992+00 AA 01:22:32:00", "
6BA-1A VA1A2 001 24 01:22:41:00 01:23:13:00 00:00:32:00 A005 08/17/04 15:06:13:13 002 6BA 1A VFX EH536452-6994+01 EH536452-7042+01 AA 01:22:41:00", "
6BA-3A VA1A2 001 24 01:23:13:15 01:23:42:00 00:00:28:15 A005 08/17/04 15:11:04:19 002 6BA 3A VFX EH536452-7090+09 EH536452-7133+05 AA 01:23:13:12", "
6BA-4A VA1A2 001 24 01:23:42:00 01:24:13:00 00:00:31:00 A005 08/17/04 15:12:46:20 002 6BA 4A VFX EH536452-7134+04 EH536452-7180+12 AA 01:23:42:00", "
6BA-5A VA1A2 001 24 01:24:13:00 01:24:43:00 00:00:30:00 A005 08/17/04 15:14:09:25 002 6BA 5A VFX EH536452-7181+11 EH536452-7226+11 AA 01:24:13:00", "
6BA-6A VA1A2 001 24 01:24:43:15 01:25:13:20 00:00:30:05 A005 08/17/04 15:15:36:18 002 6BA 6A VFX EH536452-7226+03 EH536452-7271+07 AA 01:24:43:12", "
6BB-3A VA1A2 001 24 01:25:14:05 01:26:11:15 00:00:57:10 A005 08/17/04 15:51:12:10 002 6BB 3A EH536452-7459+11 EH536452-7545+11 AA 01:25:14:04", "
6BB-5A VA1A2 001 24 01:26:12:00 01:27:15:05 00:01:03:05 A005 08/17/04 15:56:02:26 002 6BB 5A EH536452-7638+10 EH536452-7733+06 AA 01:26:12:00", "
6BB-6A VA1A2 001 24 01:27:15:05 01:28:12:10 00:00:57:05 A005 08/17/04 16:00:17:19 002 6BB 6A EH536452-7734+03 EH536452-7819+15 AA 01:27:15:04", "
PUNCH-1A VA1A2 001 24 01:28:12:20 01:28:15:25 00:00:03:05 A006 08/17/04 16:01:16:02 002 PUNCH 1A EH536455-6980+00 EH536455-6984+12 AA 01:28:12:16", "
6BC-2A VA1A2 001 24 01:28:15:20 01:29:08:00 00:00:52:10 A006 08/17/04 16:08:46:26 002 6BC 2A EH536455-7067+12 EH536455-7146+04 AA 01:28:15:16", "
6BC-3A VA1A2 001 24 01:29:08:05 01:30:03:10 00:00:55:05 A006 08/17/04 16:10:30:03 002 6BC 3A EH536455-7150+06 EH536455-7233+02 AA 01:29:08:04", "
6BC-4A VA1A2 001 24 01:30:03:25 01:31:02:00 00:00:58:05 A006 08/17/04 16:12:23:08 002 6BC 4A EH536455-7233+01 EH536455-7320+05 AA 01:30:03:20", "
6BD-1A VA1A2 001 24 01:31:02:10 01:32:00:05 00:00:57:25 A006 08/17/04 16:29:23:03 002 6BD 1A EH536455-7324+09 EH536455-7411+05 AA 01:31:02:08", "
6BD-2A VA1A2 001 24 01:32:01:05 01:32:57:15 00:00:56:10 A006 08/17/04 16:31:09:11 002 6BD 2A EH536455-7415+01 EH536455-7499+09 AA 01:32:01:04", "
6BE-2A VA1A2 001 24 01:32:58:10 01:33:35:00 00:00:36:20 A006 08/17/04 17:03:48:23 002 6BE 2A VFX EH536455-7524+00 EH536455-7579+00 AA 01:32:58:08", "
6BE-3A V 001 24 01:33:35:25 01:34:23:05 00:00:47:10 A006 08/17/04 MOS 6BE 3A VFX EH536455-7580+09 EH536455-7651+09 AA 01:33:35:20", "
5A-3A VA1A2 001 24 01:34:23:15 01:34:46:20 00:00:23:05 A006 08/17/04 17:51:10:11 002 5A 3A EH536455-7734+09 EH536455-7769+05 AA 01:34:23:12", "
5A-4A VA1A2 001 24 01:34:46:20 01:35:10:10 00:00:23:20 A006 08/17/04 17:52:02:10 002 5A 4A EH536455-7770+02 EH536455-7805+10 AA 01:34:46:16", "
5A-5A VA1A2 001 24 01:35:10:25 01:35:34:10 00:00:23:15 A006 08/17/04 17:53:37:00 002 5A 5A EH536455-7805+00 EH536455-7840+04 AA 01:35:10:20", "
PUNCH-1A VA1A2 001 24 01:35:35:05 01:35:39:05 00:00:04:00 A007 08/17/04 17:54:02:07 002 PUNCH 1A EH536455-9000+00 EH536455-9006+00 AA 01:35:35:04", "
5B-1A VA1A2 001 24 01:35:39:10 01:35:54:10 00:00:15:00 A007 08/17/04 18:12:12:29 002 5B 1A EH536455-9000+10 EH536455-9023+02 AA 01:35:39:08", "
5B-2A VA1A2 001 24 01:35:54:20 01:36:16:00 00:00:21:10 A007 08/17/04 18:12:42:18 002 5B 2A EH536455-9025+13 EH536455-9057+13 AA 01:35:54:16", "
PUNCH-1B VA1A2 001 24 01:36:16:00 01:36:19:20 00:00:03:20 B001 08/17/04 18:13:04:26 002 PUNCH 1B EH536456-9003+00 EH536456-9008+08 AA 01:36:16:00", "
5-1B VA1A2 001 24 01:36:19:15 01:36:36:15 00:00:17:00 B001 08/17/04 17:29:34:22 002 5 1B EH536456-9010+08 EH536456-9036+00 AA 01:36:19:12", "
5-2B VA1A2 001 24 01:36:36:25 01:36:56:10 00:00:19:15 B001 08/17/04 17:32:30:20 002 5 2B EH536456-9038+13 EH536456-9068+01 AA 01:36:36:20", "
5A-3B VA1A2 001 24 01:36:56:15 01:37:18:00 00:00:21:15 B001 08/17/04 17:51:11:26 002 5A 3B EH536456-9136+03 EH536456-9168+07 AA 01:36:56:12", "
5A-4B VA1A2 001 24 01:37:17:25 01:37:37:15 00:00:19:20 B001 08/17/04 17:52:02:18 002 5A 4B EH536456-9169+02 EH536456-9198+10 AA 01:37:17:20", "
5A-5B VA1A2 001 24 01:37:38:10 01:38:03:10 00:00:25:00 B001 08/17/04 17:53:32:28 002 5A 5B EH536456-9200+10 EH536456-9238+02 AA 01:37:38:08", "
END-1B VA1A2 001 24 01:38:03:10 01:38:28:05 00:00:24:25 B001 08/17/04 17:53:59:00 002 END 1B EH536456-9238+14 EH536456-9242+12 AA 01:38:03:08", "
"}}

Brad_Bumgarner · July 19, 2005, 2:17pm

Can you email me an ALE file? I believe I know how you want the data formatted. I know I can parse it, I just don’t know how to explain the process very well. I will email you back the script and comment what I’m doing and why.

My email address is bbumgarner@earthlink.net

Brad Bumgarner, CTA