Hi everyone,
I’m building a scenario in Make and I’d like to set up a filter that only allows rows to pass if they do not contain any digits (0–9).
For example:
"Hello World" 
should pass
"Test123 or Test 123 " 
should not pass
Does anyone know the correct formula for this case?
Thanks a lot for your help!
Hello @c_silvio and Welcome to the Make Community!
There may be other ways to handle this, but here’s one…
In your filter, you use replace to replace the first digit found with something else, then in that same filter do not allow the value to pass if it contains that same “something else”. For example:
For “donotpass”, choose a string that isn’t likely to appear in your text.
In your example this would turn “Test123 or Test 123 “ into “Testdonotpass23 or Test 123 “ and since it now contains “donotpass” the filter will not let it pass!
Hope that makes sense and hope it helps!
Welcome to the Make community!
This is easy. All you need is a pattern filter like this: \d
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
Hello everyone.
Thanks for your response, it works.
I would like to add a condition to this filter:
OR
text operators does not contain: @ (this is to filter fields that contain an email address)
When I add this, the first condition no longer works (does not match pattern: \d) and the filter lets everything through.
Do you have any idea what the problem is?
Thanks in advance.
You want to use an AND operator, because you only want those with BOTH true to pass through to the next module.
You can also learn more about this in these Make Academy units:
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
