Elastic Search - Regex to match string/number as substring

Question

I am new in Elastic Search. I want to perform search for the pattern "Achieved by Ron@" in following string where "Achieved by" string is constant and Ron is a username that can change followed by '@' constant character:

"this is very useful, Achieved by Ron@, Let's meet sometime, Achieved to John"

I tried below query but it didn't work.

{
    "query": {
        "query_string": {
           "query": "/Achieved by .*@/"
        }
    }

}

Please help me out to solve this problem.

Tim Biegeleisen · Accepted Answer · 2018-04-02 08:25:11Z

1

This is speculative, but the pattern .* is greedy, meaning it will consume as much text as possible before hitting the @. You may try making the dot lazy:

"query": "/Achieved by .*?@/"

If this doesn't work, perhaps because the Perl lazy dot is not supported, then another option is:

"query": "/Achieved by [^@]*@/"

edited Apr 2, 2018 at 8:25

answered Apr 2, 2018 at 7:07

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

slayer Over a year ago

Thanks for your reply. Above suggestion somewhat worked well but not completely. This is also giving false positive results where only "Achieved" word is present in String. This is returning true for "Achieved from" also.

Tim Biegeleisen Over a year ago

@slayer I don't see how that could be possible, though I don't know your flavor of regex.

slayer Over a year ago

It is Lucene RegEx engine.

Tim Biegeleisen Over a year ago

Can you give a full example of a field which is matching my answer, but which should not be?

slayer Over a year ago

String where I am running your answer: "I am running late, Achieved from his goal, Cool, Since you are late I'm going back". Here, it is returning true with your solution. I don't have idea how it is possible.

Collectives™ on Stack Overflow

Elastic Search - Regex to match string/number as substring

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related