Edit JSON fields

[Nine Zero]

I am looking to do the following

1. Take in a JSON file
2. Show the user a column in EXCEL filled with the values of a specific field
3. Have the column next to it be what the field will be changed to
4. Edit the JSON file with the new renamed values

1. Sample JSON
[
{
color: "red",
value: "#f00"
},
{
color: "green",
value: "#0f0"
},
{
color: "blue",
value: "#00f"
}
]

2. In EXCEL I would like Column A and B to have the following

A	B
Current Value For Color	Desired Value For Color
red	orange
green	purple
blue	white

3. Resulting edited JSON

[
{
color: "orange",
value: "#f00"
},
{
color: "purple",
value: "#0f0"
},
{
color: "white",
value: "#00f"
}
]

I simply need to do a bunch of replaces for a specific field

Anyway to accomplish this? VBA or no VBA does not matter.

Thanks

 

[Kerryx]

I would have just opened in a text file and did a F&R but wouldn't you also have to change the color value?

 

[Nine Zero]

I would have just opened in a text file and did a F&R but wouldn't you also have to change the color value?

This was just a sample I pulled off of Google, I really just need 1 field to be edited. And yes F&R would work but, there are over 900 replaces at any given moment. I also get that doing the F&R 900 times is the same as manually typing into each field what I need but there are a lot of fields that simply need an underscore, or a period removed (which can be accomplished via a formula) that would take care of a huge portion of them. Which is why I am looking for an Excel solution.

 

[Nine Zero]

bump