Change capital letters in mongo to camel casing?

Question

I have a collection named User, which contains the the fields firstName and secondName. But the data is in capital letters.

{
  firstName: 'FIDO',
  secondName: 'JOHN',
  ...
}

I wanted to know whether it is possible to make the field to camel case.

{
  firstName: 'Fido',
  secondName: 'John',
  ...
}

[This may help you](http://stackoverflow.com/questions/37919820/mongodb-query-to-capitalise-first-letter-in-existing-database) to solve your problem. — Vishal Kumar Sahu, Jan 28 '17 at 05:06

score 5 · Accepted Answer · answered Jan 28 '17 at 05:06

You can use a helper function to get your desired answer.

function titleCase(str) {
    return str.toLowerCase().split(' ').map(function(word) {
        return word.replace(word[0], word[0].toUpperCase());
    }).join(' ');
}

db.User.find().forEach(function(doc){
    db.User.update(
        { "_id": doc._id },
        { "$set": { "firstName": titleCase(doc.firstName) } }
    );
});

score 0 · Answer 2 · answered Apr 10 '22 at 19:19

Run an update operation with aggregate pipeline as follows:

const titleCase = key => ({
   $concat: [
      { $toUpper: { $substrCP: [`$${key}`,0,1] } },
      { $toLower: {
            $substrCP: [
               `$${key}`, 
               1,
               { $subtract: [ { $strLenCP: `$${key}` }, 1 ] }
            ]
      } }
   ]
});
db.User.updateMany(
   {},
   [
      { $set: { 
         firstName: titleCase('firstName'),
         secondName: titleCase('secondName')
      } }
   ]
)

Mongo Playground

Change capital letters in mongo to camel casing?

2 Answers2

Linked