Find and replace in array of strings in mongodb

Question

I'm using MongoDB v4.4. My document structure looks like this:

{
  _id: ObjectId("..."),
  photos: ["image1.png", "image2.png"]
},
{
  _id: ObjectId("..."),
  photos: ["image3.png", "another_image.png, image5.jpg"]
},
{
  _id: ObjectId("..."),
  photos: ["image_name.jpg", "image2.jpg"]
},

I am trying to change all the strings that contain ".png" to ".jpg".

I have tried the following:

db.users.updateMany({
  photos: { $regex: /.png/ }
}, [{
  $set: {
    "photos.$[]": { 
      $replaceOne: { 
        input: "photos.$[]", find: ".png", replacement: ".jpg" 
      } 
    }
  }
}])

This returns the error:

MongoServerError: Invalid $set :: caused by :: FieldPath field names may not start with '$'.

turivishal · Accepted Answer · 2021-08-30 08:42:25Z

7

You need to iterate the loop of photos array and replace the extension,

$map to iterate loop of photos array
$replaceOne to replace extension

db.users.updateMany(
  { photos: { $regex: ".png" } },
  [{
    $set: {
      photos: {
        $map: {
          input: "$photos",
          in: {
            $replaceOne: {
              input: "$$this",
              find: ".png",
              replacement: ".jpg"
            }
          }
        }
      }
    }
  }]
)

Playground

answered Aug 30, 2021 at 8:42

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

Find and replace in array of strings in mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related