Hi have a field named acts which displays all the different acts with below query
base search | table acts
which displays as below
Now I dont want to display any of the results which contains # in it. How can I filter them?
If acts is one of your extracted fields you can filter the same in the base search itself
<Your Base Search> acts!="*#*" | table acts