How to convert string to array of int MongoDB

Question

in my project I have an excel file that is converted in a mongodb structure data.

This is an example row:

appartamento:{
    nome: 'Appartamento',
    via: 'Via Roma 120',
    ids_stile: '2, 3 11',
    ids_personaggi: '8, 9, 21'
}

Where 'ids_stile' and 'ids_personaggi' are strings.

Is it possible to convert the ids_stile and ids_personaggi in a collection of integers to have a structure like this?

appartamento:{
    nome: 'Appartamento',
    via: 'Via Roma 120',
    ids_stile: [2, 3,  11],
    ids_personaggi: [8, 9, 21]
}

Thanks

J.F. · Accepted Answer · 2020-11-11 12:06:58Z

3

If you want to use mongo to do this, try this query:

db.collection.aggregate([
  {
    "$match": {
      "id": 0
    }
  },
  {
    "$set": {
      "appartamento.ids_stile": {
        "$split": [
          "$appartamento.ids_stile",
          ","
        ]
      },
      "appartamento.ids_personaggi": {
        "$split": [
          "$appartamento.ids_personaggi",
          ","
        ]
      }
    }
  },
  {
    "$project": {
      "appartamento.ids_stile": {
        "$map": {
          "input": "$appartamento.ids_stile",
          "as": "newArray",
          "in": {
            "$convert": {
              "input": "$$newArray",
              "to": "int",
              
            }
          }
        }
      },
      "appartamento.ids_personaggi": {
        "$map": {
          "input": "$appartamento.ids_personaggi",
          "as": "newArray",
          "in": {
            "$convert": {
              "input": "$$newArray",
              "to": "int",
              
            }
          }
        }
      },
      "appartamento.nome": 1,
      "appartamento.via": 1
    }
  }
])

Basically is get the document you want (I've used appartamento.nome but you can match by _id or whatever you want).
Then, modify the fields using $set and $split to create an string array dividied by ','.
After that project the fields overwriting these two with a new array using $map where each value from string array now is converted to int.

Example here

Edit:

To do that with many documents, only is necessary remove the $match stage.

Example here

edited Nov 11, 2020 at 12:06

answered Nov 10, 2020 at 12:00

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

2 Comments

Mauro Over a year ago

Is there a way to recusevely do it to all documents in the collections and save them all?

J.F. Over a year ago

Yes, it is possible! Remove the $match stage and works. I've updated the answer too

Robert · Accepted Answer · 2020-11-10 11:25:25Z

2

use string split and then use map and parse each string value to number.

const appartamento = {
    nome: 'Appartamento',
    via: 'Via Roma 120',
    ids_stile: '2, 3, 11',
    ids_personaggi: '8, 9, 21'
};

const appartamento2 = {
    nome: 'Appartamento',
    via: 'Via Roma 120',
    ids_stile: appartamento.ids_stile.split(", ").map(s => +s),
    ids_personaggi: appartamento.ids_personaggi.split(", ").map(s => parseInt(s)),
}

console.log(appartamento2)

answered Nov 10, 2020 at 11:25

Robert

2,7721 gold badge12 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to convert string to array of int MongoDB

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related