mongodb replace one character in many documents

Question

I have this collection in a database, it contains a lot of documents on it, i would like all instances of "Æ" to be replaced with "ae".

My documents look like this:

{ 
    "_id" : ObjectId("57071e9fee31902f0a9ad989"),
    "layout" : "normal", 
    "name" : "Æther Flash", 
    "manaCost" : "{2}{R}{R}", 
    "cmc" : 4,
    "colors" : [ "Red" ]
}

I suppose i should use something like find_one_and_update, maybe?

All i could achieve so far is to locate all of them with db.getCollection('AllCards').find({'name':{'$regex':'Æ'}}) — David Spira
– David Spira, Commented Apr 28, 2016 at 22:59
{ "_id" : ObjectId("57071e9fee31902f0a9ad989"), "layout" : "normal", "name" : "Æther Flash", "manaCost" : "{2}{R}{R}", "cmc" : 4, "colors" : [ "Red" ]} — David Spira
– David Spira, Commented Apr 28, 2016 at 23:20
Next time you should consider using the "edit" link on question to add additional informations. — Sede
– Sede, Commented Apr 28, 2016 at 23:24

martskins · Accepted Answer · 2016-04-28 23:41:42Z

3

This should work. It may take a while depending on how big you db is, which might be big considering its a MTG db ;), but it should work.

db.getCollection('AllCards').find({$or: [{name: {$regex: 'Æ'}}, {name: {$regex: 'æ'}}]}).forEach(function (x) {
    x.name = x.name.replace(/Æ/g, 'Ae').replace(/æ/g, 'ae');

    db.getCollection('AllCards').save(x);
});

Of course that only covers Æs in the name. But I suppose you can sort out how to make it work with all necessary fields.

edited Apr 28, 2016 at 23:41

answered Apr 28, 2016 at 23:36

martskins

2,9604 gold badges29 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

mongodb replace one character in many documents

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