MongoDB 将字符串类型转换为浮点类型 [英] MongoDB convert string type to float type

问题描述

遵循此处的建议 MongoDB:如何更改字段的类型?我尝试更新我的集合以更改字段的类型及其值.

Following the suggestions over here MongoDB: How to change the type of a field? I tried to update my collection to change the type of field and its value.

这里是更新查询

db.MyCollection.find({"ProjectID" : 44, "Cost": {$exists: true}}).forEach(function(doc){
    if(doc.Cost.length > 0){
        var newCost = doc.Cost.replace(/,/g, '').replace(/\$/g, '');
        doc.Cost =  parseFloat(newCost).toFixed(2);  
        db.MyCollection.save(doc);
        } // End of If Condition
    }) // End of foreach

完成上述查询后，当我运行以下命令时

upon completion of the above query, when I run the following command

db.MyCollection.find({"ProjectID" : 44},{Cost:1})

我仍然将 Cost 字段作为字符串.

I still have Cost field as string.

{
    "_id" : ObjectId("576919b66bab3bfcb9ff0915"),
    "Cost" : "11531.23"
}

/* 7 */
{
    "_id" : ObjectId("576919b66bab3bfcb9ff0916"),
    "Cost" : "13900.64"
}

/* 8 */
{
    "_id" : ObjectId("576919b66bab3bfcb9ff0917"),
    "Cost" : "15000.86"
}

我在这里做错了什么?

这是示例文档

/* 2 */
{
    "_id" : ObjectId("576919b66bab3bfcb9ff0911"),
    "Cost" : "$7,100.00"
}

/* 3 */
{
    "_id" : ObjectId("576919b66bab3bfcb9ff0912"),
    "Cost" : "$14,500.00"
}

/* 4 */
{
    "_id" : ObjectId("576919b66bab3bfcb9ff0913"),
    "Cost" : "$12,619.00"
}

/* 5 */
{
    "_id" : ObjectId("576919b66bab3bfcb9ff0914"),
    "Cost" : "$9,250.00"
}

推荐答案

问题在于 toFixed 返回的是 String，而不是 Number.然后你只是用一个新的、不同的 String 更新文档.

The problem is that toFixed returns an String, not a Number. Then your are just updating the document with a new, and different String.

来自 Mongo Shell 的示例:

Example from Mongo Shell:

> number = 2.3431
2.3431
> number.toFixed(2)
2.34
> typeof number.toFixed(2)
string

如果你想要一个 2 位小数，你必须用类似的东西再次解析它:

If you want a 2 decimals number you must parse it again with something like:

db.MyCollection.find({"ProjectID" : 44, "Cost": {$exists: true}}).forEach(function(doc){
  if(doc.Cost.length > 0){
    var newCost = doc.Cost.replace(/,/g, '').replace(/\$/g, '');
    var costString = parseFloat(newCost).toFixed(2);
    doc.Cost = parseFloat(costString);
    db.MyCollection.save(doc);
  } // End of If Condition
}) // End of foreach

这篇关于MongoDB 将字符串类型转换为浮点类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！