Having serious trouble splitting memo field

[BDavidson]

I have an old paradox database that i'm bringing into access. One of the fields is a "note" that for some reason contains all notations rather than having it split by day. Examples below.

Current Data

Project Number | Note
172 | 4/19/94 BJD: This is an example note.9/03/2008 BJD:This is a second example note 12/22/2009 BJD:This is the third example note.

Hopeful end result:

Project Number | Note | Date | UserID | Note |
172 | 4/19/94 | BJD | This is an example note. |
172 | 9/03/2008 | BJD | This is a second example note |
172 | 12/22/2009 | BJD | This is the third example note. |

The note field doesn't end with any specific character, sometimes it has a space, sometimes a period, sometimes nothing separating the end from the next date. Any help would be greatly appreciated. Thanks in advance

 

[BDavidson]

Unfortunately the data was stored in a memo field that didn't have any sort of required delineation beyond the insertion of a date/username.

Thanks, I'll check out the hex editor idea, though i really don't see how that would help...