I have many rows of data, similar to the {" CONDITION ": [{" JGXKZH" : "4101002", "LXR" : "pei-lin zhao"}]} then how do I use excle quickly modify the format of each line each row at the beginning of {deleted and then add a} in the content the end and then remove the content inside of [] to steps for great god teach

CodePudding user response:

Delete the brackets "replace" function, before and after the curly braces formula; Or, in the "replacement" in the software, such as application UltraEdit paste back, the software that can limit first end of the line,

CodePudding user response:

Do you want into this format?
"COUNT" : {" JGXKZH ":" 4101002 ", "LXR" : pei-lin zhao}
"Steps:
1. {" replaced by "
2. [{replaced with "["
3. "}]} is replaced by "}

CodePudding user response:

First step 2, then 1, 3

CodePudding user response:

Combined with a 4
Have replaced [" {"