Need help removing *text* from field
I need help removing certain text from a text field. Below is the sample text.
Basically, in this case, I need all the text removed (including the date) starting at 11/19/2013 and ending at the last phone number of, in this case, Jeff Kate. Some records may only have two contacts- this one has three. And it's possible that the Work # may be blank, but if it is, the text "Work:" will still be there.
There may be text in this field that doesn't have this format (date time stamp, name, cell, home, work). That stuff I need to keep.
Thanks in advance for any help!
11/19/2013 4:46:31 AM Bob Smith Cell: (555) 555-1212 Home: (555) 555-1212 Work: (555) 555-1212 11/19/2013 4:46:30 AM Laura Pluto Cell: (555) 555-1212 Home: (555) 555-1212 Work: 11/19/2013 4:46:30 AM Jeff Kate Cell: (555) 555-1212 Home: Work: (555) 555-1212 89/11Emergency Contacts: Bill Smith (aunt) (555) 555-1212 and Tim and John Henry (uncle) (555) 555-1212