$rename MongoDB field names using $regex in mongo shell?

Question

I've looked at other questions, but none that I've seen want to modify field names with a $regex in a mongo shell. My attempts to use db.collection.update with $rename and a $regex have failed.

I have a collection with documents like this:

{
    "_id" : "CWE-693",
    "Name" : "Protection Mechanism Failure",
    "Description" : "The product does not use or incorrectly uses a protection mechanism that provides sufficient defense against directed attacks against the product.",
    "Modes_Of_Introduction" : [
        "Architecture and Design",
        "Implementation",
        "Operation"
    ],
    "Common_Consequences" : [
        "Bypass Protection Mechanism"
    ]
}

I'd like to rename all of the field names (other than "_id") to eliminate the underscores ("_") so the document instead looks like this:

{
    "_id" : "CWE-693",
    "Name" : "Protection Mechanism Failure",
    "Description" : "The product does not use or incorrectly uses a protection mechanism that provides sufficient defense against directed attacks against the product.",
    "ModesOfIntroduction" : [
        "Architecture and Design",
        "Implementation",
        "Operation"
    ],
    "CommonConsequences" : [
        "Bypass Protection Mechanism"
    ]
}

Is this possible with db.collection.update, with $rename and a $regex? Are there other mongo shell programmatic ways to achieve this?

@JohnnyHK Well, I guess that's the answer. Write it here as an answer and I'll accept it. — rickhg12hs
– rickhg12hs, Commented Dec 12, 2018 at 18:39

JohnnyHK · Accepted Answer · 2018-12-12 18:41:38Z

2

$rename can only be used with plain strings, not regexes.

So you'd have to write code to read a representative doc, iterate over the field names and assemble a $rename operation to execute.

answered Dec 12, 2018 at 18:41

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

Collectives™ on Stack Overflow

$rename MongoDB field names using $regex in mongo shell?

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