How to convert all elements in an array from strings to numbers in MongoDB

Question

Given a collection of MongoDB documents where each document have an array of numbers stored as strings. How do i modify all documents to store the element as numbers instead of strings?

Currently, the documents are structured like this:

{
"coordinates": ["7.83", "58.08"]
}

The desired output would be like this

{
"coordinates": [7.83, 58.08]
}

The collection have 1M+ documents, and solutions that involves processing the documents in code, would not be desirable.

I have tried to use the $toDouble operator combined with $updateMany, without success.

Gibbs · Accepted Answer · 2022-06-07 08:58:11Z

2

db.collection.update({},
[ //Aggregate update
  {
    "$set": {
      "coordinates": {
        $map: {
          input: "$coordinates",
          in: {
            $toDouble: "$$this" //Aggregate operators required to convert
          }
        }
      }
    }
  }
],
{
  "multi": true,
  "upsert": false
})

PLayground

answered Jun 7, 2022 at 8:58

Gibbs

23.1k14 gold badges84 silver badges147 bronze badges

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

Collectives™ on Stack Overflow

How to convert all elements in an array from strings to numbers in MongoDB

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