Email Parser

Extract data from incoming emails and automate your workflow

MENUMENU
DOCUMENTATION TOPICSDOCUMENTATION TOPICS

Multiple step parsing

Multiple step parsing means that, instead of using the default email fields like Body or Subject as input, you use another field of the same parser. For example:

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

Example

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 filtering and replacing method to remove the 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

In the next step we apply 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