Convert text string into JSON array

Question

I have a file with data written by a lua script that I am trying to convert into JSON. The data is formatted as follows:

{"ID" : 51, "name" : "John", "relationship" : "Friend", "Lat" : 56.166609, "Long" : 27.157364}
{"ID" : 52, "name" : "Sally", "relationship" : "Friend", "Lat" : 55.895501, "Long" : 26.753631}

I need to convert it to:

[
    {
"time" : 0.00, 
"ID" : 51, 
"name" : "John",
"relationship" : "Friend",
"Lat" : 56.166609, 
"Long" : 27.157364
},
{
    "time" : 0.00, 
    "ID" : 52, 
    "name" : "Sally",
    "relationship" : "Friend",
    "Lat" : 55.895501, 
    "Long" : 26.753631
    }
]

Currently I am trying the code below, which works with a single line of data but not with multiple lines of data. I haven't been able to figure out what additional steps are needed for multilpe lines (the actual data file will be hundreds of lines) :

        const response2 = await fetch('Export.log');
        var data2 = await response2.text();
        var formatted = JSON.parse(data2);
        console.log(formatted);

you need format json output?

daremachine
– daremachine

2020-06-28 23:14:39 +00:00
Commented Jun 28, 2020 at 23:14 — daremachine
– daremachine, Commented Jun 28, 2020 at 23:14

Chris · Accepted Answer · 2020-06-28 23:14:46Z

1

Looks like you want to take data2 and do the following.

var formatted = JSON.parse('[' + data2.trim().replace(/\n/g, ',') + ']')

So take your data, replace all of the new lines with commas, and then wrap it in an array.

The trim is to take off a trailing new line if there are any.

answered Jun 28, 2020 at 23:14

Chris

2,8261 gold badge31 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert text string into JSON array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related