have some VBA code which returns some JSON from an API into a single cell. I would like to be able to run text to columns so that I can split up the JSON into individual columns based on a delimiter, but when I try to do so, all the JSON disappears and just leaves the opening "{".
Example of JSON:
And I would like it to appear, using the "," as a delimiter:
Thanks for the help
Example of JSON:
JSON:
"{
""status"": 200,
""likelihood"": 10,
""data"": {
""id"": ""abcdefg"",
""full_name"": ""david smith"",
}"
And I would like it to appear, using the "," as a delimiter:
"status": 200 | "likelihood": 10 | "data": { "id": "abcdefg" |
Thanks for the help