MongoDB，在$convert(聚合)中将带逗号的字符串转换为double。无法分析数字“%1,533.07”

db.collection.aggregate([
  {
    $project: {
      convertedValue: {
        $convert: {
          input: { $replaceOne: { input: "$yourField", find: ",", replacement: "" } },
          to: "double"
        }
      }
    }
  }
])

db.collection.aggregate([
  {
    $project: {
      convertedValue: {
        $convert: {
          input: {
            $reduce: {
              input: { $split: ["$yourField", ","] },
              initialValue: "",
              in: { $concat: ["$$value", "$$this"] }
            }
          },
          to: "double"
        }
      }
    }
  }
])