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. 

Extract_data.png

Extract_output.png

Extract_Test.xlsx

binu_acs

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

Parse_json_31072025.yxmd