我有一個這樣的集合。
{
"_id": "6137392141bbb7723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":9000000001
},
{
"_id": "6137392141bbe30723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":9000000002`
}
目的是用 91 更新電話號碼欄位。我想在用戶的每個電話號碼前插入 91。
{
"_id": "6137392141bbb7723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":919000000001
},
{
"_id": "6137392141bbe30723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":919000000002
}
我正在嘗試 updateMany
const doc = await User.updateMany(
{},
{ $set: {
//missing here
}},
{
new: true,
runValidators : true
});```
uj5u.com熱心網友回復：
我不確定這是最好的解決方案，但是
parseInt('91' user.phonenumber.toString())
uj5u.com熱心網友回復：
要么添加 910000000000
data.forEach(item => item.phonenumber = 910000000000)
或者
連接“91”并將字串轉換回數字
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)uj5u.com熱心網友回復：
假設您有一個來自陣列的資料
[{
"_id": "6137392141bbb7723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":919000000001
},
{
"_id": "6137392141bbe30723",
"email": "[email protected]",
"lastname": "Cagle",
"firstname": "Brooke",
"phonenumber":919000000002
}]
首先，您需要將其決議為 JavaScript，如果它是檔案，則需要 fs 模塊才能提取資料。
// parse to js
const array = JSON.parse(data);
const formattedArray = array.map( user => ({...user, phonenumber: Number(`91${user. phonenumber}`) }))
const newData = JSON.stringify(formattedArray)
就是這樣，希望對你有幫助
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/414137.html
標籤：
上一篇：使用貓鼬進行嵌套分組