Insert Square Brackets

Question

Hello,

I am dealing with json output file for which I need to add these square bracket to. Down below i have shown how Name can have different values and how the outcome should look like. Please advise, thank you.

Data1

"Name": "AAA","BBB","CCC"

Expected Outcome1

"Name": ["AAA","BBB","CCC"]

Data 2

"Name":""

Expected Outcome2

"Name": []

Data 3

"Name":"HHH"

Expected Outcome3

"Name": ["HHH"]

IraWatt · Accepted Answer

Hey @jakaur32,

Here is a simple way to do this with a formula tool:

Any questions or issues please ask :)
HTH!
Ira

ddiesel · Accepted Answer

Hi @jakaur32!

If you have different string formats coming in, you will need to write conditional statements for each type of record. If there are not too many different string formats, then you can build the logic into the one formula tool as @IraWatt recommended.

Even though it is more tools, I sort of lean towards a solution like this because it is dynamic to many different expected strings of data.

In the concatenation function of the Summarize tool, you have the option to add a start, separator, and end characters:

Hope this helps!

Deb