Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hey everyone,

 

I have a zap that listens for a Discord message then searches that message for a date and time. To search for the pattern of the date I’m using “Extract Pattern” on the Formatter using this pattern: 

\d/\d\d/\d\d\d\d|\d\d/\d/\d\d\d\d|\d/\d/\d\d\d\d|\d/\d/\d\d|\d/\d\d/\d\d|\d\d/\d/\d\d|\d\d/\d\d/\d\d|\d/\d\d/\d\d\d\d

Essentially this is just looking for all variations of typing the date. This works pretty well except when people put a 4 digit year. Even though I have the pattern in there, the zap just picks the first two digits out of the year and thinks it’s found the MM/DD/YY pattern instead. So now people putting the date 2022 are having their events post in ‘20. I’ve tried putting the 4 digit year pattern at the beginning and end of the “Pattern” field but this continues to happen either way.

 

How can I make sure the zap searches for the 4 digit year first and if it finds it, uses that instead of looking for another possible match?

 

Thanks!

Hi @FWD!

I am by no means a regex expert, but I did some Googling and found this expression, which might help:

^(?:(?:31(\/|-|\.)(?:0?[13578]|1[02]))\1|(?:(?:29|30)(\/|-|\.)(?:0?[1,3-9]|1[0-2])\2))(?:(?:1[6-9]|[2-9]\d)?\d{2})$|^(?:29(\/|-|\.)0?2\3(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00))))$|^(?:0?[1-9]|1\d|2[0-8])(\/|-|\.)(?:(?:0?[1-9])|(?:1[0-2]))\4(?:(?:1[6-9]|[2-9]\d)?\d{2})$

 

I think that the format of this will match for dates that are day/month/year, so if you’re working with US formatted dates, you’ll need to switch it around a bit. I found a way of testing it on this site. As an fyi, that’s not an official Zapier resources, just something a found with some Googling, so do check the formula for yourself before you use it. 

 

If anyone else has any ideas on how to edit @FWD’s query to account for years that may be 2 or 4 digits, it’d be great to hear them!

Hey Danvers,

 

This seems to capture some date formats but not all of them. I unfortunately don’t have the know how to fix this to include the ones I need which are:

 

MM/DD/YYYY, M/DD,YYYY, MM/D/YYYY, M/D/YYYY, MM/DD/YY, M/DD/YY, MM/D/YY, and M/D/YY

 

 

Just a quick update, I found a good expression: ^(?:(?:(?:0?[13578]|1[02])(\/|-|\.)31)\1|(?:(?:0?[1,3-9]|1[0-2])(\/|-|\.)(?:29|30)\2))(?:(?:1[6-9]|[2-9]\d)?\d{2})$|^(?:0?2(\/|-|\.)29\3(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00))))$|^(?:(?:0?[1-9])|(?:1[0-2]))(\/|-|\.)(?:0?[1-9]|1\d|2[0-8])\4(?:(?:1[6-9]|[2-9]\d)?\d{2})$

 

That matches all formats I need, however it doesn’t seem to extract the pattern out of a wall of text. Only if the only input is the date itself. For my purposes, I need the expression to find the date in a wall of text like this:

Date to be sent: 09/05/2022
Time to be sent: 10:00AM

 

Can someone please help me modify this to search in the full message and not only look for the full message to match the pattern? Thanks in advance!

Hey @FWD! I’ve checked with a few folks on our end but unfortunately, we’re not super familiar/well-versed in regex expressions. 😔 So while we can’t help from the Zapier side, I will leave this thread open incase there is another community member who might be able to help!

CCing @Troy Tessalone, @MohSwellam @Moshe770 and @andywingrave here incase any of y’all have ideas to share!

Terms & Conditions