Data parsing problem

[TJ2]

Trying to extract data into columns that are originally all combined into one Excel cell and has a lot of extra characters and spaces

Attached is the file with sample data and a tab with the desired outcome. The actual data contains thousands of rows with similar data.

Any help would be appreciated. 

[aatalai]

@TJ2 try using the json parse tool

[binu_acs · Accepted solution]

@TJ2, the given JSON was broken, because of that the JSON tool was throwing an error. I fixed the JSON and parsed the data.