AnsweredAssumed Answered

Need help removing *text* from field

Question asked by JohnV_1 on Jul 28, 2015
Latest reply on Jul 30, 2015 by philmodjunk

Title

Need help removing *text* from field

Post

 

Hi,

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

Outcomes