Mongo - Replace substring of array

Question

Im having trouble replacing a substring in some documents. This would be the example of one of the many similar documents:

{
"images" : [
    {
        "url" : "https://example/1234"
    },
    {
        "url" : "https://example/afaef"
    },
    {
        "url" : "https://example/abcdef"
    }
]}

I need to replace all the 'example' substrings for say 'newresult'

This is my approach

db.collection.find({'images.url':/.*example*/} , {'images.url':true, _id:false}).forEach(function(doc) {
doc.images.url = doc.images.url.replace('example', 'newresult');
db.collection.save(doc);});

However im getting many errors trying different forms of this like doc.images.url is undefined. Also tried some different yet still unsuccesful variations of this.

I would really appreciate some insights on what im doing wrong, or if theres a better way to do this. Thanks.

Does this answer your question? How to replace substring in mongodb document — whoami - fakeFaceTrueSoul
– whoami - fakeFaceTrueSoul, Commented Apr 3, 2020 at 18:55
Since the doc that you pass to save does not have an _id it will create a new document in the collection. Was that the intent? — Joe
– Joe, Commented Apr 3, 2020 at 19:01

mickl · Accepted Answer · 2020-04-03 19:21:09Z

2

You can try some MongoDB solution but if it's one-off JS script then you're close, the only thing you're missing is that images is an array so you need to use .map() like below:

let doc = {
"images" : [
    {
        "url" : "https://example/1234"
    },
    {
        "url" : "https://example/afaef"
    },
    {
        "url" : "https://example/abcdef"
    }
]};

doc.images= doc.images.map(({url, ...rest}) => ({url: url.replace('example', 'newresult'), ...rest}));

console.log(doc);

edited Apr 3, 2020 at 19:21

answered Apr 3, 2020 at 18:55

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

7 Comments

Andres Julia Over a year ago

Mmm, isnt working. I think it could be because my doc is in the format of {"images":[...]} as opposed to "images":[...] ?

mickl Over a year ago

can you console.log(doc) and paste it here?

mickl Over a year ago

It might also be that you're not retrieving _id so if you want to update current docs then you have to get rid of _id: false

Andres Julia Over a year ago

[object BSON] is the output

mickl Over a year ago

try printjson(doc)

|

Collectives™ on Stack Overflow

Mongo - Replace substring of array

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related