Keith
Registered User.
- Local time
- Today, 04:47
- Joined
- May 21, 2000
- Messages
- 129
I'm not sure if I am biting off more than I can chew. I have a text field in each record in my database (Inherited) The db has nearly 5,000 records. I would like to split the field into records in a seperate table. An Example of the table as is now;
I want to create a table as follows;
Is this possible in one hit or do I need to process the records without dates first and then run another process to split those with Dates? I say dates but the field is a text field. About 15-20% of the records contain dates which are always enclosed in parenthesis.
Code:
MemberID Boats
5882 Opossum(78-80) (87-89) Otter(80-84) Opportune(91-93) Turbulent(97-00).
5883 Astute Auriga Aeneas Affray Amphion
2407 H34 O10 Porpoise Trenchant Tapir.
Code:
MemberID Boat From To
5882 Oppossum 1978 1980
5882 Oppossum 1987 1989
5882 Otter 1980 1984
5882 Opportune 1991 1993
5882 Turbulent 1997 2000
5883 Astute
5883 Auriga
5883 Aeneas
5883 Affray
5883 Amphion
Etc.
Last edited: