Extracting CountryCode And CountryName from TextInput into Two columns

[Masond3]

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 ? 

CountryCode	CountryName
AR	ARGENTINA
AM	ARMENIA
AW	ARUBA
CL	CHILE
CN	CHINA

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 solution]

You could add braces and JSON Parse it,

[ShankerV]

Hi @Masond3 

One way of doing this.

Step 1: Input

Step 2: 

Step 3:

"(\u+)":"(\u+)"(\u+)":"(\u+)

Many thanks

Shanker V