Question: I am using Postgressql. I have a column with nested json data as follows - ( one row shown ) : [ { Province
I am using Postgressql. I have a column with nested json data as follows one row shown: Province:"BALOCHISTAN","District":"NSIRABAD","Tehsil":"DM JAMALI","Uc:"QUBA SHER KHAN SHARQI B"AIC":"Abdul Qadir","Team":""DeploymentStatus":"Deployed","IMEI":""PID":"Z"Type":"First Last Ping","ReportingStart":"::"ReportingEnd":"::"ExpectedPings":"ActualPings":"ReportingStatus":"Reporting","Date":""LastUpdatedAt":"::Province:"BALOCHISTAN","District":"NSIRABAD","Tehsil":"DM JAMALI","Uc:"QUBA SHER KHAN SHARQI B"AIC":"Mitha Khan "Team":""DeploymentStatus":"Deployed","IMEI":""PID":"Z"Type":"First Last Ping","ReportingStart":"::"ReportingEnd":"::"ExpectedPings":"ActualPings":"ReportingStatus":"Reporting","Date":""LastUpdatedAt":"::Province:"BALOCHISTAN","District":"NSIRABAD","Tehsil":"DM JAMALI","Uc:"QUBA SHER KHAN SHARQI B"AIC":"Abdul Qadir","Team":""DeploymentStatus":"Deployed","IMEI":""PID":"Z"Type":"First Last Ping","ReportingStart":"::"ReportingEnd":"::"ExpectedPings":"ActualPings":"ReportingStatus":"Reporting","Date":""LastUpdatedAt":":: I want to extract IMEI,ReportingStart,ReportingEnd as seperate columns.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
