When parsing JSON string in SAS, it may be cumbersome at times.

The REGEXP_EXTRACT function in  Tableau lets you enter the column name and then the JSON key pattern.

REGEXP_EXTRACT(<column name>,'”<Variablename>” : “((\\”|[^”])*)”‘)

The only downside it picks up only the first value that matches that JSON key.


To know more about it, check out: