MongoDB query to capitalise first letter in existing database

Question

Here is the problem,

I want to capitalise the first letter of a name in my existing database, just wanted to know if there is any query so that i can make it possbile.

what i want -- in my database so many names is in unformatted ways.. like lucy, Sean, jon and so on. i want to make them in a formatted ways like. Lucy. Sean, Jon. Can anyone help me with this?

Thanks in advance.

So your effort. What you have tried so far to solve your problem, so that you can get help or suggestions. — Shrabanee, Jun 20 '16 at 10:13
tried https://docs.mongodb.com/manual/reference/operator/aggregation/toUpper/ — user6409738, Jun 20 '16 at 10:17
You want to update in the data base with capitalized name, right? — Shrabanee, Jun 20 '16 at 10:20
@titi23 yes.. but not in full capital words.. but in a standard form (Only capitalized the first letter of the fisrtname collection) for example, not in JON but in Jon — user6409738, Jun 20 '16 at 10:30
Try [bulk update](https://docs.mongodb.com/manual/reference/method/Bulk.find.update/) — Shrabanee, Jun 20 '16 at 10:51
Duplicate of http://stackoverflow.com/questions/37910462/how-to-do-string-in-proper-case-using-mongodb — KaSh, Jun 20 '16 at 11:15
it wont work..! bacause it will find a single word and update it with capital for example it will make my name Aman like AmAn — user6409738, Jun 20 '16 at 11:18
Possible duplicate : http://stackoverflow.com/questions/41906508/change-capital-letters-in-mongo-to-camel-casing/41906522#41906522 — Sourabh Bhagat, Jan 28 '17 at 09:35

score 1 · Answer 1 · answered Jun 20 '16 at 11:48

it may not be the best solution. the only hiccup in below suggestion is to get "3" of $substr:["$name1",1,3] dynamically. but gives you a start?

db.toupper.aggregate([{$project:{name:{$concat:[{$toUpper:{$substr:["$name1",0,1]}},{$substr:["$name1",1,**3**]}]}}}])

below is the result

 db.toupper.find()

 "_id" : ObjectId("5767ca0badb381a5cc0d19cd"), "name1" : "lean" }
 "_id" : ObjectId("5767ca3aadb381a5cc0d19ce"), "name1" : "lean" }

 db.toupper.aggregate([{$project:{name:{$concat:[{$toUpper:{$substr:["$name1",0,1]}},{$substr:["$name1",1,3]}]}}}])

 "_id" : ObjectId("5767ca0badb381a5cc0d19cd"), "name" : "Lean" }
 "_id" : ObjectId("5767ca3aadb381a5cc0d19ce"), "name" : "Lean" }

MongoDB query to capitalise first letter in existing database

1 Answers1

Linked