# Kibana Visualization Regex Exclusion issue
**URL:** https://discuss.elastic.co/t/kibana-visualization-regex-exclusion-issue/338695
**Category:** Kibana
**Tags:** lens
**Created:** [July 18, 2023, 3:26pm UTC](https://discuss.elastic.co/t/kibana-visualization-regex-exclusion-issue/338695 "2023-07-18T15:26:19Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@turboz](https://discuss.elastic.co/u/turboz)
#### Post date: [July 18, 2023, 3:26pm UTC](https://discuss.elastic.co/t/kibana-visualization-regex-exclusion-issue/338695/1 "2023-07-18T15:26:19Z")
I'm trying to create a table that shows the top 5 source IPs, but only public IPs.
I notice there is an advanced section with "Exclude values" I turned on regex and put in the following regex.
`/(^127\.)|(^10\.)|(^172\.1[6-9]\.)|(^172\.2[0-9]\.)|(^172\.3[0-1]\.)|(^192\.168\.)/`
However, the results don't change aftewards. Am I doing sometihng wrong?
---
### Author:  [@Rios](https://discuss.elastic.co/u/Rios)
#### Post date: [July 19, 2023, 7:00am UTC](https://discuss.elastic.co/t/kibana-visualization-regex-exclusion-issue/338695/2 "2023-07-19T07:00:40Z")
Try with additional .\*
`(^127\..*)|(^10\..*)` ...
---
### Author:  [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [July 19, 2023, 8:02am UTC](https://discuss.elastic.co/t/kibana-visualization-regex-exclusion-issue/338695/3 "2023-07-19T08:02:19Z")
Hi @turboz
no need to add the `^`, something like that should work:
```auto
(127\.)|(10\.)|(172\.1[6-9]\.)|(172\.2[0-9]\.)|(172\.3[0-1]\.)|(192\.168\.).*
```
---
### Author:  [@turboz](https://discuss.elastic.co/u/turboz)
#### Post date: [July 19, 2023, 6:42pm UTC](https://discuss.elastic.co/t/kibana-visualization-regex-exclusion-issue/338695/4 "2023-07-19T18:42:14Z")
I tried removing the `^`, but that didn't work. After some further research I didn't realize how limited Lucene is for regex...
---
### Author:  [@turboz](https://discuss.elastic.co/u/turboz)
#### Post date: [July 19, 2023, 7:14pm UTC](https://discuss.elastic.co/t/kibana-visualization-regex-exclusion-issue/338695/5 "2023-07-19T19:14:30Z")
So here is another working solution. Rios has a good one as well, see comment below on that. Either solution will provide the same result.
`127\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}|10\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}|172\.16-31\.[0-9]{1,3}\.[0-9]{1,3}|192\.168\.[0-9]{1,3}\.[0-9]{1,3}`
@Rios I did try a simlar regex to that, but you have to remove the `^` for it to work. Thanks for your contribution!
`127\..*` | ... | ...
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 16, 2023, 7:14pm UTC](https://discuss.elastic.co/t/kibana-visualization-regex-exclusion-issue/338695/6 "2023-08-16T19:14:52Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.