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
Hopeful end result:
The note field doesn't end with any specific character, sometimes it...