Skip to Content
0
Former Member
Jun 30, 2009 at 12:52 AM

Extract date/time stamp and modifier name from memo field

64 Views

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.