Parsing Entire Email Body

How To
,
1

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 pghatraju@gmail.com
wrote:

Yes definitely!

On Sat, Nov 11, 2023 at 12:37 PM Pranav Ghatraju pranav@integr8ai.io
wrote:

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 pghatraju@gmail.com
wrote:” and standardize such that it will work regardless of date, time or sender email?

Thanks,
Pranav

2

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:

image
image904×1312 98.9 KB

2 Likes
3

Hi Donald,

Thanks for the reply!

Unfortunately that did not work.

4

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.

2 Likes