finding multiple strings
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
but is there a way of listing the field once and multiple strings?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for this link!!! So useful in working through/learning RegEx!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My pleasure x)
RegEx is one of the most powerful Data Cleaning tool once you learn how to use it
