SOLVED
key word
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ntudev
8 - Asteroid
08-15-2022
01:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
is there a way to filter out anything that says 'no movement'? regardless of the numbers attached to it? i would only like to be left with ' Moved From'
no movement10 |
no movement30 |
Moved from54 |
no movement90 |
Moved from94 |
Moved from64 |
no movement80 |
no movement70 |
Solved! Go to Solution.
Labels:
- Labels:
- Expression
4 REPLIES 4
DataNath
17 - Castor
08-15-2022
01:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use a filter tool with the following expression:
!Contains([Field], ‘no movement’)
Replace ‘Field’ with whatever your column is called. What you want will come out of the top (True) anchor.
IraWatt
17 - Castor
08-15-2022
01:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @ntudev,
Easiest way to do this is with the filter tool using the does not contain option:
Any questions or issues please ask
Ira Watt
Technical Consultant
Watt@Bulien.com
PhilipMannering
16 - Nebula
08-15-2022
01:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use the Filter Tool with the expression,
not contains([My Field Name], 'no movement')
It's case insensitive. Obvs replace [My Field Name] with your field.
PhilipMannering
16 - Nebula
08-15-2022
01:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It appears I have provided a duplicate solution. Apologies.