R
RJ
I receive these automated reports daily in Microsoft Outlook. I bring them
into Microsoft Access and a single field is created. What I need to do is
somehow parse the data so I see each of the 6-digit numbers that begin with 3
and associate each of the 6-digit numbers to the date listed at the top of
the report. My example report is far below and what I want the result to
look like is just below -
313221 10/7/08
313222 10/7/08
313223 10/7/08
313224 10/7/08
313225 10/7/08
SAMPLE REPORT
Date : 10-07-08 [23:11]
Page : 1
Company : 730
PRINT NEW PROJECT DAT
-----------------------------------------------------------------------------------------------------------+
ProjNr.| Date | Description | Created By |Project Manager
| Address
-----------------------------------------------------------------------------------------------------------+
313223 | 10-07-08| |fretyed |PAT |ATLANTA, GA
30339
--- --- --- --- -313224 | 10-07-08| |dwal
|PAT |NASHVILLE, TN 37201
313225 | 10-07-08| |dwal |PAT |ATLANTA, GA
30339------------------------------------------------------------------------------------------------------------------+313221
| 10-07-08| |dwalker | |NEW YORK, NY 10019
313222 | 10-07-08| |dwal | |CAMBRIDGE, MA 02141
into Microsoft Access and a single field is created. What I need to do is
somehow parse the data so I see each of the 6-digit numbers that begin with 3
and associate each of the 6-digit numbers to the date listed at the top of
the report. My example report is far below and what I want the result to
look like is just below -
313221 10/7/08
313222 10/7/08
313223 10/7/08
313224 10/7/08
313225 10/7/08
SAMPLE REPORT
Date : 10-07-08 [23:11]
Page : 1
Company : 730
PRINT NEW PROJECT DAT
-----------------------------------------------------------------------------------------------------------+
ProjNr.| Date | Description | Created By |Project Manager
| Address
-----------------------------------------------------------------------------------------------------------+
313223 | 10-07-08| |fretyed |PAT |ATLANTA, GA
30339
--- --- --- --- -313224 | 10-07-08| |dwal
|PAT |NASHVILLE, TN 37201
313225 | 10-07-08| |dwal |PAT |ATLANTA, GA
30339------------------------------------------------------------------------------------------------------------------+313221
| 10-07-08| |dwalker | |NEW YORK, NY 10019
313222 | 10-07-08| |dwal | |CAMBRIDGE, MA 02141