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 .
see attached.. got the rest working except this...great software too .
Attachments
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:
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.
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.