Importing json file where rows have missing columns
Hi, I have downloaded my full streaming history from Spotify, which is a JSON file. When trying to import the file to JMP, using the CSV "Data with preview" import helper I have a few problems. The first problem is that comma is used both as a delimiter between columns and inside some of the data strings. I solved this by opening the file in Notepad and replacing all "," with < as a unique delimi...
vince_faller