mongodb - Mongo db : data uploaded using CSV has Null stored as String in Mongo document

Question

I tried uploading data into Mongodb using CSV from Mongodb Compass. In the CSV, some of the fields have Null values stored in them. But, after uploading those fields in Mongo, documents have "Null" stored as String. Is there a way to store Null fields from CSV with the type Null?

Answer 1

You can correct easily later:

db.contacts.update({a:"Null"}, {$set: {a: null}},{multi:true} )

or you can remove those fields from the document:

db.contacts.update({a:"Null"}, {$unset: {a:1}},{multi:true} )