Database

[{"geometry":"POINT (72.548355 23.042458)"}]

Query

db.collection.update({},[{"$set":{"geometry":{$let:{vars:{"arr":{$split:["$geometry"," "]}},in:{"type":{$concat:[{$toUpper:{$substr:[{$first:"$$arr"},0,1]}},{$toLower:{$substr:[{$first:"$$arr"},1,{$strLenCP:{$first:"$$arr"}}]}}]},"coordinates":[{$toDouble:{$ltrim:{input:{$arrayElemAt:["$$arr",1]},chars:"("}}},{$toDouble:{$rtrim:{input:{$arrayElemAt:["$$arr",2]},chars:")"}}}]}}}}}],{"multi":true})

Result