Search Query for excluding a combination of characters and numbers

Elastic Stack Elasticsearch
1

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

2

Can somebody please help me with this...Thanks

3

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

1 Like
4

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

5

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