# Search Query for excluding a combination of characters and numbers

**URL:** https://discuss.elastic.co/t/search-query-for-excluding-a-combination-of-characters-and-numbers/146914
**Category:** Elasticsearch
**Created:** [August 31, 2018, 8:20pm UTC](https://discuss.elastic.co/t/search-query-for-excluding-a-combination-of-characters-and-numbers/146914 "2018-08-31T20:20:05Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![vshankara](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@vshankara](https://discuss.elastic.co/u/vshankara)
#### Post date: [August 31, 2018, 8:20pm UTC](https://discuss.elastic.co/t/search-query-for-excluding-a-combination-of-characters-and-numbers/146914/1 "2018-08-31T20:20:05Z")

</div>

I have a requirement to query for user information but need to exclude a combination of alphabatical characters and numbers. I could easily do this in a regex but not sure on lucene syntax

For eg: need to exclude abc1234 or zzz2345 but include something like testuser or tes12ab

---

<div class="post-metadata">

### Author: ![vshankara](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@vshankara](https://discuss.elastic.co/u/vshankara)
#### Post date: [September 4, 2018, 1:31am UTC](https://discuss.elastic.co/t/search-query-for-excluding-a-combination-of-characters-and-numbers/146914/2 "2018-09-04T01:31:20Z")

</div>

Can somebody please help me with this...Thanks

---

<div class="post-metadata">

### Author: ![insomniac](https://avatars.discourse-cdn.com/v4/letter/i/bb73d2/32.png) [@insomniac](https://discuss.elastic.co/u/insomniac)
#### Post date: [September 4, 2018, 4:10am UTC](https://discuss.elastic.co/t/search-query-for-excluding-a-combination-of-characters-and-numbers/146914/3 "2018-09-04T04:10:31Z")

</div>

The search bar does support regex.

[https://www.elastic.co/guide/en/elasticsearch/reference/6.3/query-dsl-query-string-query.html#query-string-syntax](https://www.elastic.co/guide/en/elasticsearch/reference/6.3/query-dsl-query-string-query.html#query-string-syntax)

---

<div class="post-metadata">

### Author: ![vshankara](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@vshankara](https://discuss.elastic.co/u/vshankara)
#### Post date: [September 4, 2018, 7:15pm UTC](https://discuss.elastic.co/t/search-query-for-excluding-a-combination-of-characters-and-numbers/146914/4 "2018-09-04T19:15:13Z")

</div>

Thank you. I missed seeing the regex patterns, thanks for pointing out to me. I was able to resolve this using the pattern "UserID:/[^0-9]+/" which basically excludes anything with 1 or more numbers

---

<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 2, 2018, 7:15pm UTC](https://discuss.elastic.co/t/search-query-for-excluding-a-combination-of-characters-and-numbers/146914/5 "2018-10-02T19:15:23Z")

</div>

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