Hi have a field named acts which displays all the different acts with below query
base search | table acts
which displays as below
displayed screen
113;screen
hjgjh#kjhk
jhgjhyg#
Now I dont want to display any of the results which contains # in it. How can I filter them?
Try like this
base search | table acts | eval acts=mvfilter(NOT match(acts,"#"))
If acts is one of your extracted fields you can filter the same in the base search itself
<Your Base Search> acts!="*#*"
| table acts
Here's one way.
base search | regex acts!="#" | table acts
Try like this
base search | table acts | eval acts=mvfilter(NOT match(acts,"#"))