I need to extract all date/time stamps and modifier name strings from the Work Log memo field - or conversely, filter out all of the comments after the date/time modifier strings. I have the string extract but it only extracts the first one. I need to loop until all are found - how can I do this? The memo field will look something like this:
3/5/2009 3:32:05 PM John Doe
Comments - string can be any length
3/4/2009 12:35:43 PM John Doe
Comments - string can be any length
3/4/2009 12:28:17 PM Jane Dough
Comments - string can be any length and include date format 2009-06-04 14:20 CST.
3/4/2009 12:27:47 PM Mary HadaliddleLam
Comments - string can be any length
3/4/2009 12:26:55 PM Lamseedivy
Comments - string can be any length
3/4/2009 12:15:22 PM Mareseedoes
Comments - string can be any length.