Template
single collection
multiple collections
mgodatagen
update
indexe
explain
Stage
Database
bson
mgodatagen
[{"postalCode":"A5A 5A5"},{"postalCode":"A AA B BB"}]
Query
db.collection.update({},[{$addFields:{postalCode:{$replaceAll:{input:"$postalCode",find:" ",replacement:""}}}}],{multi:true})
Result