Data Spilt : Special Characters Question

[DelData]

Hi there,

 i have attached a sample excel showing what I need help with....i am trying to extract the company names for positions 0,1 and 2 below in grey.......

what i need is to produce a table below in green showing each id's and there associated company name for positions 1,2 and 3 respectfully...

 ..attached is sample excel to help......any help for me on this would be great :)

[binuacs · Accepted solution]

@DelData This can be done using the Jason Parse tool, but your given data has some missing ": " and "]" and the end

[DelData]

Thank you for this......your solution worked perfectly......

I would have struggled with this one... Thank you for taking time out to help me ‌‌👍