I am working on parsing a JSON output that has multiple rows in the downloaded data. The goal being to get the JSON converted into a CSV dataset.
The best option I have found so far is Substring, but I would rather use REGEX instead of looping through this formula n times.
Substring([JSON_Name],FindString([JSON_Name], ".")+1,Length([JSON_Name]))
I have also tried these, but neither works.
REGEX_Replace([JSON_Name], ".*.\s", "")
REGEX_Replace([JSON_Name], ".*\\.", "")