Filter tool question
- 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
Hello All,
I have a question regarding the filter tool and the "does not contain" expression. I was hoping to have 1 expression with 4/5 different phrases to remove from the data but had to apply the filter tool 4 times instead (See beneath)
I don't come from a programming background so the expression writing and the nuances associated with that, I haven't mastered yet.
How should I have approached this to?
Thanks
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use AND in a single formula:
!CONTAINS([Status Upon Delivery], "error") AND !CONTAINS([Email], "sales") AND ....
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ChrisTX is correct.
Try the attached workflow to see that logic in action.
Edit: updated workflow with another example.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks both, this is great.
I will work on the expression writing.