how to add a number to a integer field using nodejs and mongodb

Question

I have a collection like this.

 {
"_id": "6137392141bbb7723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":9000000001
},
{
"_id": "6137392141bbe30723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":9000000002`
}

Aim is to update the phonenumber field with 91. i want to insert 91 infront each and every phonenumber of users.

{
"_id": "6137392141bbb7723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":919000000001
},
{
"_id": "6137392141bbe30723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":919000000002
}

im trying with updateMany

const doc = await User.updateMany(
            {}, 
            { $set: { 
                //missing here
              }},
            {
                new: true, 
                runValidators : true
            });```

Hello, first I want to ask about the data. Is it from MongoDB or just a JSON file ? — Anas Ben Yaiche
– Anas Ben Yaiche, Commented Jan 17, 2022 at 10:12
Does this answer your question? Modify object property in an array of objects — pilchard
– pilchard, Commented Jan 17, 2022 at 10:13
You ask how to add a number to a integer field using nodejs but your attempt is not node but mongo — mplungjan
– mplungjan, Commented Jan 17, 2022 at 10:21
You might not want to use a number type for phone number fields - I would probably prefer a string type. See en.wikipedia.org/wiki/E.164 — soupy-norman
– soupy-norman, Commented Jan 17, 2022 at 10:24

utf_8 · Accepted Answer · 2022-01-17 10:14:11Z

0

I'm not sure that it's the best solution, but

parseInt('91' + user.phonenumber.toString())

answered Jan 17, 2022 at 10:14

utf_8

1152 silver badges12 bronze badges

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

Comments

mplungjan · Accepted Answer · 2022-01-17 10:20:08Z

0

EITHER add 910000000000

data.forEach(item => item.phonenumber += 910000000000)

OR

concatenate "91" and convert the string back to number

data.forEach(item => item.phonenumber = +("91"+item.phonenumber))

const data =  [{
"_id": "6137392141bbb7723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":9000000001
},
{
"_id": "6137392141bbe30723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":9000000002
}]

data.forEach(item => item.phonenumber += 910000000000)
console.log(data)

edited Jan 17, 2022 at 10:20

answered Jan 17, 2022 at 10:14

mplungjan

180k29 gold badges183 silver badges246 bronze badges

Comments

Anas Ben Yaiche · Accepted Answer · 2022-01-17 10:21:43Z

0

Let Suppose that you have a data from as an array

[{
"_id": "6137392141bbb7723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":919000000001
},
{
"_id": "6137392141bbe30723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":919000000002
}]

First of all, you need to parse it to JavaScript, if it's a file you require fs module to be able to extract the data.

// parse to js
const array = JSON.parse(data);
const formattedArray = array.map( user => ({...user, phonenumber:  Number(`91${user. phonenumber}`) })) 
const newData = JSON.stringify(formattedArray)

That is it, I hope it can help you

answered Jan 17, 2022 at 10:21

Anas Ben Yaiche

3253 silver badges7 bronze badges

Collectives™ on Stack Overflow

how to add a number to a integer field using nodejs and mongodb

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related