Our department uses a Microsoft Access database to manage roughly 300,000 records. The front-end of the system allows users to add comments to a donor’s record. As you might guess, the comment field became the wild west with no standards for how comments were input. To make matters worse, prior to me starting here, in an instance where a donor already had a comment assigned to their record, rather than creating a new comment (a new line in the back-end table), the staff would open the existing comment and add additional notes to the end. ONLY DELIMITED BY A SPACE!

This is a follow-up question on A working RegEx match that begins at the first of two OR-words takes the unwanted last OR-word instead if I place more RegEx before it [duplicate]. Thanks go to the helpful remarks of this user and this user under that question.