how to avoid displaying the field which contains #?

[pavanae]

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

kjhkh;jkh

hjgjh#kjhk
jhgjhyg#

Now I dont want to display any of the results which contains # in it. How can I filter them?

[niketn]

If acts is one of your extracted fields you can filter the same in the base search itself

<Your Base Search> acts!="*#*"
| table acts

[richgalloway]

Here's one way.

base search | regex acts!="#" | table acts

[somesoni2 · Accepted solution]

Try like this

base search | table acts | eval acts=mvfilter(NOT match(acts,"#"))