Email Parser

Hi,

The easiest way is to use a "simple email parser" where the "start after" value is the wildcard expression: *, FL and the "continues until" value is end of line:


Also, it can be done with a expression match email parser. A bit more complex but also possible. The regular expression is: FL\s*(?'postal_code'\d*-\d*)


It is also possible with a script-based email parser. This is the most complex way:

[syntax=csharp]
using EmailAndParser.ScriptingInterface;
using System.Collections.Specialized;
using System.Net.Mail;

public class MyScriptBasedEmailParser : ScriptBasedParser
{
public override NameValueCollection ParseEmail(MailMessage msg)
{
// This will be the fields that this script-based email parser will return
NameValueCollection returned_fields = new NameValueCollection();


// the email body is
string email_body = msg.Body;

// Get the position of "FL" in the email body
int position = email_body.IndexOf("FL");

string s;

if (position > 0)
s = email_body.Substring(position+2);
else
s = ""; // FL not found

returned_fields.Add("postal_code", s);

return (returned_fields);
}
}
[/syntax]

For the city you need to use a "expression match" email parser. Set it to capture a regular expression from the text only version of the email body. Then fill "city" in the field name and enter this regular expression:

(?'city'.*), FL

That should work fine. If you have any other questions feel free to post again.

Note that the field name must be 'city'.

Check if your configuration is the same as mine:
If it still does not work please send me your configuration file (Preferences->Backup and restore settings->Backup) You can change your email souce settings first for privacy.

Hi Steve,

That file seems to be corrupted. Please, send me it by email (to support@automatedemailparser.com) or post it here again