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
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 (17.1KiB)Viewed 978 times
The regular expression here is (you can copy/paste):
And the regular expression here is:
from_field.jpg (11.57KiB)Viewed 974 times
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:
Code: Select all
(?'display_name'.*?)<.*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})(\]?)