Add regular expressions to datasets

How to add regexes to datasets

1. Start editing a simple dataset that you want to supplement with regular expressions. Add a new column and select Regex field from the dropdown menu.
   
2. Add one more column to your dataset and select Regex.
   
3. In the Regex field column, select a field where you want to look for matching strings: body, from, to, cc, bcc, subject, location, recipient's or sender's first, last, or full name. In the Regex column, enter your regular expression.
   

Your dataset is ready, and you can use the data it contains in your outgoing email messages.

How to extract data from datasets with regexes

Suppose you often receive emails with some order IDs in the message body and those order IDs have an abbreviated country name as part of their structure, like this: "DE73491".

When replying to such an email, you'd like its message body to be checked for a specific abbreviation so that you can automatically include relevant information from your dataset in your reply. You'll need:

• The Regex field column in your dataset with the body option selected
• Regular expressions covering the structure of the order IDs in the Regex column, for example \bDE[0-9]{5}\b
• The Insert macro (the Insert Dataset Value option) in your template to bring the necessary details from the dataset to your reply, for example the name of the country and the delivery period
  

When replying with such a template, you'll get the name of the necessary country and the delivery period automatically returned from your dataset and inserted into your email message.