I am trying to parse the following, which is in a comments text field, and create 4 fields: CommentName, CommentDate, CommentTime, and Comment. Any help would be greatly appreciated. By the way, I would prefer to do this in LotusScript. Here is what the text in the original comment field looks like...
John Doe 02/07/2008 01:51:44 PM Comments blah blah blah blah blah blah
____________________________________________________
Jane Doe 02/07/2008 11:38:59 AM Comments blah blah blah blah blah blah
____________________________________________________
Betty Doe 02/06/2008 03:24:26 PM Comments blah blah blah blah blah blah
____________________________________________________
John Doe 01/31/2008 02:42:17 PM Comments blah blah blah blah blah blah
____________________________________________________
John Doe 01/31/2008 10:01:18 AM Comments blah blah blah blah blah blah
____________________________________________________
Robert Doe 01/25/2008 01:00:46 PM Comments blah blah blah blah blah blah
____________________________________________________
John Doe 01/25/2008 12:00:37 PM Comments blah blah blah blah blah blah
Thank you in advance!!

URGENT: Extract date from a text st... (tyreek moore 31.Oct.08)
. . 