Parse JSON Macro (v9.2)… is there a better way?

[martin]

Hi @rcraighead,

Just by reading your post, I think you can do this:

1. set a variable into text: get all JSON data you want to retrieve and connect these data with a unique string.
   E.g., Set Local__myVar to:
   %JSONValue%Item.value.Template%UNIQUESTRING%JSONValue%Item.value.Whatever%UNIQUESTRING%JSONValue%Item.value.Whatever%

2. Search that variable with RegEx and save them into the variables. See the example here given by @JMichaelTX :

Split Each Word Into Separate Variable

Well, you have to first define and tell us how each "word" is separated. The example you gave of "New York, NY" clearly contains multiple "words" as commonly defined, and as defined by normal RegEx rules. Once we know the delimited between fields (what you are calling words) it is fairly easy. If you get this by a copy from cells in the same row in Excel, then the fields will be separated by TABs. Here is a simple solution using TABs. It is just an example written in response to your reque…