is there a best/fastest way to find multiple strings in one field? is "contains" faster than "=" and is there a function where you can list the field once and all the strings you're looking for, in the field?
thanks
becki kain
Solved! Go to Solution.
What I would do is in a loop, looking like
Contains ([Field], "x")
OR
Contains ([Field], "y")
OR
....
That way with a simple copy/paste you can gain some time
but is there a way of listing the field once and multiple strings?
something like Regex could help then, If you are not familiar with it I recommend you to first :
- Check that link https://community.alteryx.com/t5/Data-Preparation-Blending/RegEx-Examples-12-Handy-Use-Cases/td-p/36...
- Take a look at the live training
Just did a test, you can build an expression looking like : .*[ae].* in the RegEx tool (using match mode) (What is between the [ ] are the character you are looking for)
Here is an attached workflow for you to take a look at
that way you don't have to list your field more and once
Then you can filter and the true value to get a clear view of what you are looking for
hope that helps
thanks
Thanks for this link!!! So useful in working through/learning RegEx!!
My pleasure x)
RegEx is one of the most powerful Data Cleaning tool once you learn how to use it
User | Count |
---|---|
17 | |
16 | |
14 | |
6 | |
5 |