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?
Help with - email fields with multiple coma separated value parsing - i.e. City, State. Zip USA

see attached.. got the rest working except this...great software too .
Attachments
Field in Question.JPG
Field in Question.JPG (10.68KiB)Viewed 3423 times
Hi Jeremy,

Addresses are sometimes a bit difficult to parse. They tend to use a not very fixed format but if your emails stick to the one you attached you can capture the fields (city, zip, state etc) with the help of this regular expression:

Address:\s+(?'address'.*?),(?'city'.*?),\s+(?'state'\w\w)\s+(?'zip'.*?),(?'country'.*)

If, for some reason, more commas are used, the state is missing or something like that, the parsing will fail. You can make the regular expression more or less flexible but it is better to ask the sender to use always the same format.

I have attached some screenshots that show how to use it.
Attachments
address_parsing.jpg
country_parsing.jpg
zip-parsing.jpg
state_parsing.jpg