Extract data from a email body

Hi All,

Lets say, I’m receiving emails in below format and I need to extract the Date from email Content.
Column is “Requested Pickup Window
Date is “09/28

Is there a way to extract these information from a email body ?

Thanks in advance

Screenshot 2023-09-27 at 15.37.53

Welcome to the Make community!

You can use a Text Parser “Match Pattern” module with this regular expression pattern



For more information, see Text Parser in the Make Help Center:

Match Pattern
The Match pattern module enables you to find and extract string elements matching a search pattern from a given text. The search pattern is a regular expression (aka regex or regexp), which is a sequence of characters in which each character is either a metacharacter, having a special meaning, or a regular character that has a literal meaning.


Thanks samliew for the quick response.

One more thing I need to check, Lets assume there are two Dates in this field, in that case is there a way to get both of this dates ?

e.g. 09/28 , 09/10


Yes, switch the “Global match” option to True, and you’ll get a bundle for each match.


And also,

Is there a way to capture Client ID in the table ?


It depends, you’ll need to provide more information.

In future, please create a new thread for each question. This makes it easier for others with the same problem to search for the answer. Thank you for your cooperation!

1 Like