Parsing Entire Email Body

Hi everyone,

I am building an auto replier and taking reply emails from my customer and putting them in AirTable.

When I use the Email module, the Text Content outputs something like this:

Hi Pranav,

I am looking forward to our call!

On Sat, Nov 11, 2023 at 12:38 PM Pranav Ghatraju

Yes definitely!

On Sat, Nov 11, 2023 at 12:37 PM Pranav Ghatraju

Thank you, looking forward to it.

How do I write a regex expression such that the only text that gets sent to AirTable is all of the text before “On Sat, Nov 11, 2023 at 12:38 PM Pranav Ghatraju
wrote:” and standardize such that it will work regardless of date, time or sender email?


Hi @Pranav_Ghatraju,

I am not sure if this will work for you, but you could try a Match Pattern Text Parser module and use this as the pattern:
([\s\S\r\n]?)(?=[\r\n]On \w, \w* \d{1,2}, \d{4} at)

Here’s the configuration of the options in the module:


Hi Donald,

Thanks for the reply!

Unfortunately that did not work.

I just realized when I copied and pasted the regex I forgot to quote it so markup took over. You’d need to tweak the regex to work on your exact output from the email module.