Deleting records on different rows...

[Jim]

Hi all, having a problem with a database.

I have a feed from a mainframe that sends over data in the following
format, I've numbered the rows 1 through 8 for this message. Under
Entry 208, there is a begin, cancel, begin, and end record, along with
a time. I need to keep only the second Begin record (3) and the End
record (4); I'm not concerned about records 1 and 2. Some sort of
thing that finds a cancel record, and deletes the prior begin record...
but I'm not sure how.

Similarly, with Entry 0232, I want to keep record 5 and 8, but delete
record 6 and 7... Does anyone have an idea how this could be done?

Entry Type Time OprCycleSort
1 0208 BEGIN 041417 6 050 093=39=SRT
2 0208 CANCEL 041459 $.00 0
3 0208 BEGIN 041509 6 050 093=39=SRT
4 0208 END 041718 $368,521.94 68

5 0232 BEGIN 085809 6 050 086=02=41B
6 0232 SUSPEND 090528 $.00 0
7 0232 RESTART 090530 6 050 086=02=41B
8 0232 END 091658 $22,433,881.48 3,343

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Probably have to read the data sequentially parsing as you go. E.g.:

If "begin"
Read & hold data lines until hit "end"
If hit "cancel"
Drop held data lines
If hit "end"
Place held data lines into storage
Repeat until end of data stream

The "held data lines" can be saved in a variable or a table until done,
then saved to a file/table or something else.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQedOHIechKqOuFEgEQIt0QCbBBveBTNJciTPtQy1ZjAD1c qnjeQAn2RR
6aN9oce7ZcHXRnL3V5xCtK35
=eCfx
-----END PGP SIGNATURE-----
Jim wrote:

Hi all, having a problem with a database.

I have a feed from a mainframe that sends over data in the following
format, I've numbered the rows 1 through 8 for this message. Under
Entry 208, there is a begin, cancel, begin, and end record, along with
a time. I need to keep only the second Begin record (3) and the End
record (4); I'm not concerned about records 1 and 2. Some sort of
thing that finds a cancel record, and deletes the prior begin record...
but I'm not sure how.

Similarly, with Entry 0232, I want to keep record 5 and 8, but delete
record 6 and 7... Does anyone have an idea how this could be done?

Entry Type Time OprCycleSort
1 0208 BEGIN 041417 6 050 093=39=SRT
2 0208 CANCEL 041459 $.00 0
3 0208 BEGIN 041509 6 050 093=39=SRT
4 0208 END 041718 $368,521.94 68

5 0232 BEGIN 085809 6 050 086=02=41B
6 0232 SUSPEND 090528 $.00 0
7 0232 RESTART 090530 6 050 086=02=41B
8 0232 END 091658 $22,433,881.48 3,343