Extracting CountryCode And CountryName from TextInput into Two columns

Question

HI All,

Need some Help,

I have received a text input in the following format

"AR":"ARGENTINA","AM":"ARMENIA","AW":"ARUBA"",CL":"CHILE","CN":"CHINA"

Is there an easy way to get the above into the format below ?

CountryCodeCountryNameARARGENTINAAMARMENIAAWARUBACLCHILECNCHINA

Observations:

* After Every Comma is a new Country Code 
* After every Semi Colon is the countryName for the Country Code

Looking forward to your help

Regards

Masond3

philipmannering · Accepted Answer

You could add braces and JSON Parse it,