What would be the best way to extract the “answer” out of this value in a column. The ids change and never static.
The string value:
{
"id": 80,
"type": "parent",
"question": "<span style="font-size:22px;">Test Question here. (pick three things)</span>",
"section_id": 8,
"options": {
"10245": {
"id": 10245,
"option": "Apples",
"answer": "Apples"
},
"10247": {
"id": 10247,
"option": "Melons",
"answer": "Melons"
},
"10252": {
"id": 10252,
"option": "Oranges",
"answer": "Oranges"
}
},
"shown": true
}
Would like to extract the x from each “answer”: “x”.
1