# Is possible Exact match substring in kibana?

**URL:** <https://discuss.elastic.co/t/is-possible-exact-match-substring-in-kibana/200062>\
**Category:** Kibana\
**Created:** [September 18, 2019, 5:35pm UTC](https://discuss.elastic.co/t/is-possible-exact-match-substring-in-kibana/200062 "2019-09-18T17:35:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![smerzlyakov](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@smerzlyakov](https://discuss.elastic.co/u/smerzlyakov)\
**Post date:** [September 18, 2019, 5:35pm UTC](https://discuss.elastic.co/t/is-possible-exact-match-substring-in-kibana/200062/1 "2019-09-18T17:35:06Z")

</div>

Hello.  
Is it possible to exact match substring of text field in kibana?  
I try to search "Get-System", but i get results like

![59](https://us1.discourse-cdn.com/elastic/original/3X/1/6/162da552e5f67c6528b3ae402ba752b52d5a73e5.png)  
What ways are possible to solve the problem?  
I know, that it is possible to write a DSL query to elasticsearch directly - but it is not a solution for analytics..  
So, what options are possible?

---

<div class="post-metadata">

**Author:** ![alisongoryachev](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alisongoryachev/32/111352_2.png) [@alisongoryachev](https://discuss.elastic.co/u/alisongoryachev)\
**Post date:** [September 18, 2019, 8:02pm UTC](https://discuss.elastic.co/t/is-possible-exact-match-substring-in-kibana/200062/2 "2019-09-18T20:02:26Z")

</div>

Hi @smerzlyakov!

Have you tried a wildcard (\*) query without quotation marks?

---

<div class="post-metadata">

**Author:** ![smerzlyakov](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@smerzlyakov](https://discuss.elastic.co/u/smerzlyakov)\
**Post date:** [September 19, 2019, 8:18am UTC](https://discuss.elastic.co/t/is-possible-exact-match-substring-in-kibana/200062/3 "2019-09-19T08:18:04Z")

</div>

> [@alisongoryachev](#):
>
> wildcard (\*) query

Thanks for response, but it is DSL syntax, not Kibana KQL.  
I think with DSL it is better to try [match\_phrase](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-match-query-phrase.html)  
But the question is about Kibana search. Is this feature exist in KQL? If no, why?It is must-have feature!

Are there another solutions?Like changing text analyzer, or maybe i can search with Lucene syntax?

---

<div class="post-metadata">

**Author:** ![smerzlyakov](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@smerzlyakov](https://discuss.elastic.co/u/smerzlyakov)\
**Post date:** [September 19, 2019, 12:34pm UTC](https://discuss.elastic.co/t/is-possible-exact-match-substring-in-kibana/200062/4 "2019-09-19T12:34:22Z")

</div>

I have try to insert this DSL in "Edit filter" in kibana -but it doesn't work. As i inspect the query - kibana modify the final query. I cant do the wildcard query in Discovery tab with Kibana?  
Is there any way to search exact match substring in Kibana?

---

<div class="post-metadata">

**Author:** ![smerzlyakov](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@smerzlyakov](https://discuss.elastic.co/u/smerzlyakov)\
**Post date:** [September 27, 2019, 5:27pm UTC](https://discuss.elastic.co/t/is-possible-exact-match-substring-in-kibana/200062/5 "2019-09-27T17:27:14Z")

</div>

Because i do not get an answer - i send what i found.

1. If you use wildcards - do not use " symbols. It inserts "match\_phrase" in query. Use like this fileld:get\*  
Good explanation here and in related paper [Wildcard query not working as expected](https://discuss.elastic.co/t/wildcard-query-not-working-as-expected/84447/4)
2. But even wildcards and regexes not working as expected. Через жопу. I found, that escaping non-letter symbols can help. So for me this query works:  
Text:"Get-System" also you must use escaping with the space like text:"adam\moran"

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 25, 2019, 5:27pm UTC](https://discuss.elastic.co/t/is-possible-exact-match-substring-in-kibana/200062/6 "2019-10-25T17:27:25Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
