I want to take certain information from emails and export them to a database so I can call from them at a later point in time. However...the emails do not follow any specific format/layout.
Example:
"My name is Jack Slowski and I will be arriving at Colorado Springs Airport at 15:20. My flight number is 4573."
I want to be able to take the Name, Airport, Arrival Time, and Flight Number from the emails and export them into an organized excel file.
Is this possible without the emails following a format? Sometimes the emails are just one liners, other times they can be 6 lines long (never know what the emails will look like, but I always know they will have the above information somewhere in the body of the email).
Any help or guidance would be appreciated.
Thank you.
PS. I have spent a few hours looking and the only material that comes close to what I am looking for involves emails that follow a format.
EDIT: I forgot to add that the date would of arrival would also be included. That date and time comes in formats such as 11/21/2012 and 3pm, respectively (different variations of that), as well as November 21 2012 (with different variations of that as well).
Bookmarks