How to parse following json in jquery ajax success function

Question

The following JSON data retrieved from php script and now i want to parse this JSON data. Please someone help me to parse this JSON data.

[{
    "0": "1.0000",
    "AVG(Q1)": "1.0000",
    "1": "1.8000",
    "AVG(Q2)": "1.8000",
    "2": "2.0000",
    "AVG(Q3)": "2.0000",
    "3": "2.4000",
    "AVG(Q4)": "2.4000",
    "4": "1.6000",
    "AVG(Q5)": "1.6000",
    "5": "1.2000",
    "AVG(Q6)": "1.2000",
    "6": "2.0000",
    "AVG(Q7)": "2.0000",
    "7": "2.4000",
    "AVG(Q8)": "2.4000",
    "8": "0.8000",
    "AVG(Q9)": "0.8000",
    "9": "2.8000",
    "AVG(Q10)": "2.8000",
    "10": "1.8000",
    "AVG(Q11)": "1.8000"
}, {
    "0": null,
    "AVG(Q1)": null,
    "1": null,
    "AVG(Q2)": null,
    "2": null,
    "AVG(Q3)": null,
    "3": null,
    "AVG(Q4)": null,
    "4": null,
    "AVG(Q5)": null,
    "5": null,
    "AVG(Q6)": null,
    "6": null,
    "AVG(Q7)": null,
    "7": null,
    "AVG(Q8)": null,
    "8": null,
    "AVG(Q9)": null,
    "9": null,
    "AVG(Q10)": null,
    "10": null,
    "AVG(Q11)": null
}]

I tried different ways to parse this JSON but all methods failed. Please help me to parse this JSON.

I tried this but no value is displayed in the table element:

var obj = jQuery.parseJSON(data);
$.each(obj, function(key, value){          
    $('table').append('<tr><td>'+value.avg(q1)+'</td></tr>');
});

use value["AVG(Q1)"]

Parth Trivedi
– Parth Trivedi

2016-01-03 08:44:50 +00:00
Commented Jan 3, 2016 at 8:44 — Parth Trivedi
– Parth Trivedi, Commented Jan 3, 2016 at 8:44
no change same result

Sagar Yadav
– Sagar Yadav

2016-01-03 08:48:47 +00:00
Commented Jan 3, 2016 at 8:48 — Sagar Yadav
– Sagar Yadav, Commented Jan 3, 2016 at 8:48

Parth Trivedi · Accepted Answer · 2016-01-03 08:53:59Z

Please check snippet. No need to parse json.

var jsobObj = [{
    "0": "1.0000",
    "AVG(Q1)": "1.0000",
    "1": "1.8000",
    "AVG(Q2)": "1.8000",
    "2": "2.0000",
    "AVG(Q3)": "2.0000",
    "3": "2.4000",
    "AVG(Q4)": "2.4000",
    "4": "1.6000",
    "AVG(Q5)": "1.6000",
    "5": "1.2000",
    "AVG(Q6)": "1.2000",
    "6": "2.0000",
    "AVG(Q7)": "2.0000",
    "7": "2.4000",
    "AVG(Q8)": "2.4000",
    "8": "0.8000",
    "AVG(Q9)": "0.8000",
    "9": "2.8000",
    "AVG(Q10)": "2.8000",
    "10": "1.8000",
    "AVG(Q11)": "1.8000"
}, {
    "0": null,
    "AVG(Q1)": null,
    "1": null,
    "AVG(Q2)": null,
    "2": null,
    "AVG(Q3)": null,
    "3": null,
    "AVG(Q4)": null,
    "4": null,
    "AVG(Q5)": null,
    "5": null,
    "AVG(Q6)": null,
    "6": null,
    "AVG(Q7)": null,
    "7": null,
    "AVG(Q8)": null,
    "8": null,
    "AVG(Q9)": null,
    "9": null,
    "AVG(Q10)": null,
    "10": null,
    "AVG(Q11)": null
}];


$.each(jsobObj, function(key, value){          
    $('table').append('<tr><td>'+(value["AVG(Q1)"]==null?"":value["AVG(Q1)"])+'</td></tr>');
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<table>
  </table>

can u help me this json include null values i want remove it how can we do this I mean entire object which include json null values

Collectives™ on Stack Overflow

How to parse following json in jquery ajax success function

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related