AnsweredAssumed Answered

Extracting/Filtering Data based on Dates (but not in a date field)

Question asked by brianj77 on Aug 13, 2014
Latest reply on Aug 13, 2014 by Mike_Mitchell

I have some data which was exported from an Outlook file (extracted to .csv format)

I’m trying to extract/filter all messages within a date range but the date range is embedded in the body of the email so when I imported it I have one big text field containing text and dates


These dates covered are 2010 - 2014 but I need to filter out the data for only 2013-2014 i.e. any ‘conversation or contact’ which took pace within July 2013 to July 2014 using the embedded dates as the date of the contact.


Most of the data contains the ‘Sent’ with the dates (Sent: Wednesday, January 11, 2012 4:31 AM) but not always. Sometimes it is just ‘mentioned’ on the body of the text



Typical email body data (with identities hidden for this purpose)

Other data is just regular email ’threaded conversations’


=======body data==========================


From: “Web Enquiries" <>

To: <>

Sent: Wednesday, January 11, 2012 4:31 AM


…..text in body of email etc ……….


blah blah i arrive on 21 March 2012 ...blah blah




Can anyone suggest a solution please?


Thanks for your help