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:
Looking forward to your help
Regards
Masond3
Solved! Go to Solution.
Hi @Masond3
One way of doing this.
Step 1: Input
Step 2:
Step 3:
"(\u+)":"(\u+)"(\u+)":"(\u+)
Many thanks
Shanker V