key word

[ntudev]

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

[DataNath · Accepted solution]

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]

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]

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]

It appears I have provided a duplicate solution. Apologies.