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:
I am looking forward to our call!
On Sat, Nov 11, 2023 at 12:38 PM Pranav Ghatraju email@example.com
On Sat, Nov 11, 2023 at 12:37 PM Pranav Ghatraju firstname.lastname@example.org
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 email@example.com
wrote:” and standardize such that it will work regardless of date, time or sender email?