Database

[{"id":"2433-10","busiName":"ABC","srTypeId":"2433-10","nodeType":"0","pathName":"home","busiSort":10,"SampleInfo":"1:sql test question identifiers; itemid:12345;itemname:Ford;itemid:12345; itemlocation:USA;itemDate:2014","superTypeId":"002",}]

Query

db.collection.aggregate([{$addFields:{newData:{"$arrayToObject":{"$map":{"input":{$split:["$SampleInfo",";"]},"as":"newD","in":{"$split":["$$newD",":"]}}}}}}])

Result