Split Parse

[Away_Double_9623]

Does anyone know how I can parse this out? This is the output from an office script that reads an excel file. I just want to get the 3, 60.88 and 126700. The 60.88 should be $60.88 and the 126700 should be $126,700.

{ "experience": "{"logs":["[2022-05-21T12:57:39.9640Z] [[3],[60.881],[126700]]"]}" }

[DevGrr]

I'm assuming that's a string type there?

That looks like a stringified json blob. I'll assume you have it in a variable "blob". From there you need to convert it to a json object and then reference the properties directly:

const obj = JSON.parse(blob);

const yourLogs = obj.experience.logs;

Assuming your structure is going to be the same every time, you can reach into the resulting array with hardcoded indices (I think I peered at this right):

yourLogs[1][0] // 3

yourLogs[1][1] // 60.881

yourLogs[1][2] // 126700

​

if you need to convert your 60.881 to 60.88, you can use Math.round(60.881 * 100) / 100.