Company logo
  • Jobs
  • Bootcamp
  • About Us
  • For professionals
    • Home
    • Jobs
    • Courses and challenges
    • Questions
    • Teachers
    • Bootcamp
  • For business
    • Home
    • Our process
    • Plans
    • Assessments
    • Payroll
    • Blog
    • Sales
    • Calculator

0

55
Views
parse line-separated json objects in html table

I can't change json format. The data store in new line. json file:

{"ProgMode":"on","wait_h":"5","wait_m":"5","output":"1"}
{"ProgMode":"off","wait_h":"10","wait_m":"10","output":"2"}

I using below code but without bracket ([]) in json file, it doesn't work.

    var ReqJson = new XMLHttpRequest();
function response(){
    if(this.readyState == 4 && this.status == 200){
        var myObj = JSON.parse(this.responseText);
        const dbParam = JSON.stringify({table:"ProgramView",limit:20});
        let text = "<table class='table my-0'>"
        for (let x in myObj) {
        text += '<tr><td>' + myObj[x].wait_h + ':' + myObj[x].wait_m + ':' + myObj[x].output + '</td></tr>';
        }
        text += "</table>"    
        document.getElementById("dynamic_table").innerHTML = text;
    }
}

function ProccessConfig(){
    ReqJson.open("POST", "Programs.json", true);
    ReqJson.onreadystatechange = response;
    ReqJson.send()
}
ProccessConfig();

So how can I parse json that is stored with new lines and without comma and brackets?

7 months ago · Juan Pablo Isaza
2 answers
Answer question

0

You can split the input text in rows and then 'JSON.parse' the single row.

let myObj = this.responseText.split('\n')
  .filter(line => line !== "")
  .map(JSON.parse);

Example based on your string:

let text = `{"ProgMode":"on","wait_h":"5","wait_m":"5","output":"1"}
{"ProgMode":"off","wait_h":"10","wait_m":"10","output":"2"}
`

let myObj = text.split('\n')
  .filter(line => line !== "")
  .map(JSON.parse);
console.log(myObj)

7 months ago · Juan Pablo Isaza Report

0

you don't need to split and map, it is to heavy for this case, try this

var myObj = JSON.parse(`[${this.responseText.replaceAll("}\n","},")}]`);

this is a little more complicated, but much more reliable,since it is not using any special symbols

var myObj = JSON.parse(`[{${this.responseText.substring(1).replaceAll("{",",{")}]`);
7 months ago · Juan Pablo Isaza Report
Answer question
Find remote jobs