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.

Hi all,

I cannot believe I’ve not run into this before but I have a filter I’m using to only run / stop if a household name is joint (i.e. contains “First1 & First2 Last” or “First1 and First2 Last”). The issue I’m running into is that if a name contains the string “and” it will proceed incorrectly but there’s not an apparent way to filter for “_and_” (including the spaces around the and in the match criteria). Is there a way (without adding a formatter or code step) to filter on the space character? There’s also no way to set a wildcard using ‘*’ it appears. So far I’ve tried:

  • :space:and:space:
  •   and 
  • “ and “
  • _and_
  • and *

No luck. If I can avoid adding the extra step I’d love to but if not I will just add in a code block ahead of the filter to search for the “ and “ substring.

(In case this is helpful to anyone else) For now I just updated the filter to say continue if Household Name contains “and a” -or- contains “and b”…. and so on all the way down the alphabet. It makes a LONG filter and was a PITA but prevents the need for an additional task to be used on an already-long Zap.

Hi @sphynxautomation - I’ve tried  and  (with real spaces) and it seems to work for me.

 

Hi @sphynxautomation - I’ve tried  and  (with real spaces) and it seems to work for me.

 

Thanks @ikbelkirasan. My issue is the opposite. I want it to stop and not let the data pass when the word contains “ and “ (with spaces) as opposed to “and” (without spaces). However, when I enter “ and “ in the filter criteria, it’s trimming the spaces and allowing it to pass.

 

For example, “Handler” should stop vs. “John and Jessica” should continue but it’s letting “Handler” continue.

@sphynxautomation - Oh I see - It seems to be trimming the spaces when the filter is run. I don’t know if this is the intended behavior or if it’s actually a bug in the filter. You might want to reach out to the support team and see if it’s possible to work around it without adding an additional step.

Terms & Conditions