How to parse a JSON-type string

[Kopinski]

All, assume I have a string which resembles JSON-type nested code, where a certain pattern of tags reoccurs, e.g.:

[

{"family":{"code":"#T#"},"values":[{"code":"3E3W","description":"texttext1"}]},{"family":{"code":"Series"},"values":[{"code":"XXXX_XX-XX","description":"desc_Text"}]},

{"family":{"code":"BS-"},"values":[{"code":"BTAA","description":"texttext2"}]},{"family":{"code":"Feature"},"values":[{"code":"XXXX-XXXX","description":"desc_Text"}]},

{"family":{"code":"....}]},...

]

Note: that string is in one column in each row of data, describes a product in various ways [#family] and can show 20+ish  individual features as per above.  

Question: how would I best process (parse) that string, so I could isolate each iteration (i.e. starting at "family") to then (in most cases) derive the text in the description. 

Thank you!

[cmcclellan]

Look at the JSON Parse tool (in the Developer category) and see if that does what you're after 🙂 

[DawnDuong]

hi @Kopinski 

Check out the JSON Parse Tool, I think it can solve exactly what you need.