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’
From: “Web Enquiries" <firstname.lastname@example.org>
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