Help extracting strings from a cloud dataset

Hey Excel wizards,

I need a hand manipulating an exceptionally fun cloud dataset. The 'tags' have all been lumped into one column and I need to find a way to split out the below tag headers with their corresponding tag values.

I have attached a dummy dataset with the tag column as well as the 9 tag names we need to extract.

As an example:

The tag column follows the below format. The tag header is the alternating field with the suffix of : (e.g. applicationName is the tag header and Biztalk is the tag value)

"applicationName": "Biztalk","managedBy": "[email protected]","ownedBy": "[email protected]","projectName": "ztalk"

There is no order to which tag headers appear where. However, the structure of "header": followed by ","value"" is consistent.

In a nutshell, I need to find a way to search for the 9 tag headers listed in my spreadsheet and extract the respective tag values.

Hope this makes sense.

Thanks all