Exclude entities with given string from MongoDB find with RegExp

Question

My documents looks like this.

{
   "sId": "s1",
   "source": "September Challenge 1"
},
{
   "sId": "s2",
   "source": "other string multi word"
},
{
   "sId": "s3",
   "source": "September sub string to filter Challenge"
}

I was trying to find the documents only without substring " sub string to filter ". The expected result is:

{
   "sId": "s1",
   "source": "September Challenge 1"
},
{
   "sId": "s2",
   "source": "other string multi word"
},

Which regexp should I use?

I have tried different regexps but haven't achive the expected result. I saw Exclude string from MongoDB regex, but I failed to adapt the answer to my situation.

is it a substring always and not some pattern – cmgchess Apr 19 '23 at 10:30 — cmgchess, Apr 19 '23 at 10:30
not query? https://mongoplayground.net/p/LnMiXnOMpMP – cmgchess Apr 19 '23 at 10:34 — cmgchess, Apr 19 '23 at 10:34

score 0 · Answer 1 · answered Apr 20 '23 at 11:05

0

RegExp-only solution is:

db.collection.find({
  source: {
    "$regex": "^(?=.*1)((?! sub string to filter ).)*$"
  }
})

Actually, the question is the same as Regular expression to match a line that doesn't contain a word

answered Apr 20 '23 at 11:05

Sklavit

2,225
23
29

Exclude entities with given string from MongoDB find with RegExp

1 Answers1