I'm trying to scrape a .JSON file however the returned file returns multiple JSON objects in 1 .json file, resulting in a invalid json file. I'm trying to solve this by adding a [ before the JSON file and a ] after the json file. Then using a regex to add comma at the right places.
This is the file before the regex
[{"status":"success"}
{"values":{"cpu":26.5152886753948387,"ram":0.8452846061135513},"origin":"core","type":-1,"uuid":"0000-e8-de-27-176d10"}
{"values":{"cpu":25.5839236550189568,"ram":0.8452846061135513},"origin":"core","type":-1,"uuid":"0000-e8-de-27-176d10"}
]
I created the following regex: }(?!\s,|\s])
.
The problem I have is that it is still adding a , after the last } even though it's followed by a ].
What I'm getting:
[{"status":"success"},
{"values":{"cpu":26.5152886753948387,"ram":0.8452846061135513},"origin":"core","type":-1,"uuid":"0000-e8-de-27-176d10"},
{"values":{"cpu":25.5839236550189568,"ram":0.8452846061135513},"origin":"core","type":-1,"uuid":"0000-e8-de-27-176d10"},
]
Expected result:
[{"status":"success"},
{"values":{"cpu":26.5152886753948387,"ram":0.8452846061135513},"origin":"core","type":-1,"uuid":"0000-e8-de-27-176d10"},
{"values":{"cpu":25.5839236550189568,"ram":0.8452846061135513},"origin":"core","type":-1,"uuid":"0000-e8-de-27-176d10"}
]