# Two field regex in Kibana
**URL:** https://discuss.elastic.co/t/two-field-regex-in-kibana/100016
**Category:** Kibana
**Created:** [September 11, 2017, 8:17am UTC](https://discuss.elastic.co/t/two-field-regex-in-kibana/100016 "2017-09-11T08:17:05Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Maekee](https://discuss.elastic.co/u/Maekee)
#### Post date: [September 11, 2017, 8:17am UTC](https://discuss.elastic.co/t/two-field-regex-in-kibana/100016/1 "2017-09-11T08:17:05Z")
Hi,
I would like to create a regex filter that says
Hide Event\_id 1000 IF field targetusername ends with a dollar sign, otherwise.. show the Event 1000.
I have created regexp filters but cant figure out how to do the next step.
Is there any other filter that supports wildcards and regex than regexp?
Thanks
---
### Author:  [@Maekee](https://discuss.elastic.co/u/Maekee)
#### Post date: [September 11, 2017, 1:15pm UTC](https://discuss.elastic.co/t/two-field-regex-in-kibana/100016/2 "2017-09-11T13:15:29Z")
Think i solved it like this, dont know if its the best solution but it seems to work
{
"query": {
"bool": {
"must": {
"match": {
"event\_data.SubjectUserName": "Spiderman"
}
},
"filter": {
"regexp": {
"event\_data.TargetUserName": {
"value": ".\*~$"
}
}
}
}
}
}
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 9, 2017, 1:15pm UTC](https://discuss.elastic.co/t/two-field-regex-in-kibana/100016/3 "2017-10-09T13:15:56Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.