email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Need help configuring the program? Have any questions regarding its use?
I am currently using this to extract the "From email" (fromname@domain.com) and the "To email" (toname@domain.com) into they own field in a spreadsheet. What I would also like the the "From name" (Jim Norton) to be added the the third field or possibly the "From display name". I am having trouble extracting this cleanly. Depending on the sender the format seems to be different.

Thanks!
Mike
Hi,

Sorry for the late reply. While preparing a reply for your message I've found an error on how the From field was stored in the program. It was storing only the email address itself (aaaa@aaa.com) , not the display name and display address as it should be ("John Doe" <aaaa@aaa.com>). You probably noticed this.

This bug has been fixed in the Email Parser version 4.6 which is still being developed and will be released in the following weeks.

Well, answering your question, the best way to separate the display name (John Doe) and the email address (aaaa@aaa.es) from the "From" field is using regular expressions. Take a look at the following screenshots. They are self explanatory. The example is also applicable to the "To" field:
overview_parse_name_and_email_address.jpg
overview_parse_name_and_email_address.jpg (17.1KiB)Viewed 978 times
parse_display_name_and_email_address_from_From.jpg
capture_display_name.jpg
The regular expression here is (you can copy/paste):
Code: Select all(?'display_name'.*?)<.*
capture_address.jpg
And the regular expression here is:
Code: Select all([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)
from_field.jpg
from_field.jpg (11.57KiB)Viewed 974 times
sample_output_parsing.jpg