Use REGEX to replace identical words in mongoDB

Question

Use REGEX to replace identical words in mongoDB

In my attempt to use mongosh in MongoDB, I am trying to replace all instances of selected words in a collection with others.

For example, if I have the following data:


_id:12345678901
name:"Peter Parker"
profession:"Superhero"

_id:12345678902
name:"Peter Parker"
profession:"Journalist"

_id:12345678902
name:"Hulk"
profession:"Software Developer"

I want to replace all occurrences of "Peter Parker" with "Superman" in a collection named "firstList", resulting in:


_id:12345678901
name:"Superman"
profession:"Superhero"

_id:12345678902
name:"Superman"
profession:"Journalist"

_id:12345678902
name:"Hulk"
profession:"Software Developer"

Even though I attempted the following code, it did not work as expected:


db.firstList.replace({
  "name": {
    "$regex": "/( |^)Peter Parker\b/g",
    "$replaceWith": "Superman"
  }
})

javascript regex mongodb mongo-shell

Answer 1

Answer №1

Based on the data at hand, there is no need to utilize regex. Simply use the word as is in the find stage.

To update using aggregation query and [], follow this format:

db.collection.update({
  "name": {
    "$regex": "Peter Parker"
  }
},
[
  {
    "$set": {
      "name": {
        "$replaceAll": {
          "input": "$name",
          "find": "Peter Parker",
          "replacement": "Superman"
        }
      }
    }
  }
],
{
  "multi": true
})

See an example here

If desired, you can still apply regex within the find object. However, for a precise match of "Peter Parker," regex may not be necessary.

Answer 2

Based on the data at hand, there is no need to utilize regex. Simply use the word as is in the find stage.

To update using aggregation query and [], follow this format:

db.collection.update({
  "name": {
    "$regex": "Peter Parker"
  }
},
[
  {
    "$set": {
      "name": {
        "$replaceAll": {
          "input": "$name",
          "find": "Peter Parker",
          "replacement": "Superman"
        }
      }
    }
  }
],
{
  "multi": true
})

See an example here

If desired, you can still apply regex within the find object. However, for a precise match of "Peter Parker," regex may not be necessary.

Use REGEX to replace identical words in mongoDB

Answer №1

Similar questions

When verifying a MongoDB function, encountering a NameError for undefined variable 'db' is expected

Generate a text input field within a dropdown menu

Using a jQuery UI dialog for multiple checkbox selection. The post array cannot be saved for a multi-select until the dialog is opened

Could there be an issue with the couch-nano changesReader batching, or am I overlooking something important?

Node.js appears to experience delays following successful connection to local MongoDB

Pattern matching for a text field that is optional, but must be validated if inputted into

Confirm your email using a generated code through the integration of Node.js and MongoDB Atlas

Alter the cron schedule on-the-fly with a dynamic form

Avoid refreshing the page when adding an item to the cart

When a button is clicked, an Internet Explorer security exception is triggered due to the security settings

Unable to include a fresh entry into an array (the value associated with a key) within a Mongoose schema

The issue I am facing is that the map function is not functioning correctly when I click

implementing a three-tiered nested URL structure in Angular

Removing event notifications with Google Calendar API v3 (JavaScript): A Step-by-Step Guide

Tips for setting up a jQuery auto-suggest feature that fetches both the value and ID

I just made an ajax call. Now, how should I proceed with formatting the data that was returned

django.core.exceptions.ImproperlyConfigured: the specified name should be an object of type basestring

What is the connection between {{result}} and $scope.result within AngularJS?

Displaying selected values in a Multi Select Listbox upon submission of the same form when an error occurs

Exploring the world of Django, JavaScript, and intricate form designs