Email Parser

Extract data from incoming emails and automate your workflow

MENUMENU
DOCUMENTATION TOPICSDOCUMENTATION TOPICS

Multiple step parsing

 

Multiple step parsing means that the resulting text of a given parsing method is the input of the next. For example:

 

 

To enable multi-step parsing simply select another field within the same parser as input:

 

 

 

Let’s see a real example with actual text content. We have the following email body:

Vehicle Information as follows  (VIN/Year/Make/Model):
AB123456890/2016/CHEVROLET/TRAX
Number of licenses = 1
Ref # = 523-351433
Reseller =
Promotion name =
Net sales = USD 25.0000
Net Discount = USD 13.000
collected VAT = USD 0.00
Shipping = USD 0.00
VAT on Shipping = USD 0.00
Order automatically generated by backoffice.server.com at Tue, 01 Nov 2016 12:57:55

 

After applying the first step (removing like breaks) we get the following:

Vehicle Information as follows  (VIN/Year/Make/Model):AB123456890/2016/CHEVROLET/TRAXNumber of licenses = 1Ref # = 523-351433Reseller =Promotion name =Net sales = USD 25.0000Net Discount = USD 13.000collected VAT = USD 0.00Shipping = USD 0.00VAT on Shipping = USD 0.00Order automatically generated by backoffice.server.com at Tue, 01 Nov 2016 12:57:55

The next step is applying a regular expression to capture the full Ref number. If we use this one:

\d\d\d-\d\d\d\d\d\d

 

We get:

523-351433

 

And what we really need is actually the first three numbers so we apply the last step. The “starts with…. continues until…” rule would be “Starts after the line 1 character 1 and continues until a ‘-‘ character is found”. The result is:

 

523

 

As you may guess, combining multiple parsing steps make Email Parser able to capture almost anything. You can combine any number and any time of parsing method in a chain -as long as yo do not make a loop!-

Going back to the example shown. Let’s see how you can translate this logic in Email Parser. How can we tell the program to take the result of a previous step as input for another one. Really simple, take a look at this screenshots:

 

 

 

Notice that in the “Capture from” combobox not only the the default email fields (From, To….) are available. You can find also other custom fields available in the parser itself to do the multiple step parsing.