Best answer

Extracting last date using Zapier's email parser

  • 6 February 2023
  • 2 replies
  • 78 views

I’m looking to extract the latest date contained within the body of an email, and the parser seems to be having trouble. It’s for accommodation - so the way the email comes from the system, it’s structured like so:

 

 

The visitors could be staying two days or twenty days, which makes extracting the end date of the stay really difficult and the parser doesn’t seem to be learning it’s the last one. It will be the latest date contained within the email. Is there a way of parsing this? Thanks for your help!

icon

Best answer by SamB 6 February 2023, 12:38

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +11

Hi there, @chellem. Welcome to the Community! 

Often adding additional templates can help to better parse emails going forward. More on how to do that can be found here: My emails were parsed incorrectly 

If that doesn’t fix it, then what you may need to do is look at adding a Formatter (Text > Extract Pattern) or a Code by Zapier action to extract the last date. There’s a related topic in Community that discusses how to extract dates which you might find helpful in setting that up:

Hope that helps. Please do keep us in the loop on how you get on here! 🙂

We’ve given in and are trying to achieve the same through the booking system instead of involving Zapier, as we couldn’t get it working. Sorry there wasn’t a better resolution!