Extract data from a email body

[Niranga_Jayakody]

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

[samliew]

Welcome to the Make community!

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

(?<month>\d{2})/(?<day>\d{2})

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.

• The complete list of metacharacters can be found on the MDN web docs website.
• For a tutorial on how to create regular expressions, we recommend the RegexOne website.
• For an easy, quick regex generator, try the Regular Expressions generator.
• For experimenting with regular expressions, we recommend the regular expressions 101 website. Just make sure to tick the ECMAScript (JavaScript) FLAVOR in the left panel.

[Niranga_Jayakody]

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

Thanks

[samliew]

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

[Niranga_Jayakody]

And also,

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

Thanks

[samliew]

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!