How to parse this type of string using javascript or jquery?

Question

Hey guys i want to parse this type of string:

    {"1":
    [
        {"OrderItemId":832,"ItemId":995,"Price":0},
        {"OrderItemId":833,"ItemId":997,"Price":0},
        {"OrderItemId":834,"ItemId":999,"Price":0}
    ],
    "2":
    [
        {"OrderItemId":835,"ItemId":1008,"Price":0},
        {"OrderItemId":836,"ItemId":1057,"Price":0}
    ]
}

its very important for me, so please guys help me.

davidkonrad · Accepted Answer · 2012-11-06T23:25:07.130

4

Like this, if you want to access the OrderItemId

var test =  {"1":
    [
        {"OrderItemId":832,"ItemId":995,"Price":0},
        {"OrderItemId":833,"ItemId":997,"Price":0},
        {"OrderItemId":834,"ItemId":999,"Price":0}
    ],
    "2":
    [
        {"OrderItemId":835,"ItemId":1008,"Price":0},
        {"OrderItemId":836,"ItemId":1057,"Price":0}
    ]
}

alert(test["1"][0]['OrderItemId']);
alert(test["1"][1]['OrderItemId']);
alert(test["1"][2]['OrderItemId']);

alert(test["2"][0]['OrderItemId']);
alert(test["2"][1]['OrderItemId']);

UPDATE, to iterate trough test with unknown lengths

for (var i=0;i<test["1"].length;i++) {
    alert(test["1"][i]['OrderItemId']);
}

Here with full automatic enumaration

var number, count = 0;
var en = [];
for(number in test) {
    en[count]=number;
    count++;
}
for (var r=0;r<en.length;r++) {
    alert(en[r]);
    for (var i=0;i<test[en[r]].length;i++) {
        alert(test[en[r]][i]['OrderItemId']);
    }
}

edited Nov 06 '12 at 23:25

answered Oct 23 '12 at 10:57

davidkonrad

83,997
17
205
265

cool. but how can i do it when i don't know the the length? i mean to say that, how can i do it dynamically..? – Rikin Thakkar Oct 23 '12 at 10:59
still i have to give test["1"] as static. i don't want to give "1" as static. i want to parse it for any number of array.. – Rikin Thakkar Oct 23 '12 at 11:12
Hey i am not fully satisfied.Please give me solution so that i can mark your answer as accepted. – Rikin Thakkar Oct 23 '12 at 11:25
have made yet another update, last one - it should be clear now :-) – davidkonrad Oct 23 '12 at 11:44
got the exact answer what i want. thanx a ton. :) – Rikin Thakkar Oct 23 '12 at 12:01

score 3 · Answer 2 · answered Oct 23 '12 at 10:55

3

This is JSON. Use this to parse it. (or any other library you preffer, maybe jQuery)

answered Oct 23 '12 at 10:55

alexandernst

14,352
22
97
197

+1 for concisitude. You might want to give a JSON.parse code sample. – Asad Saeeduddin Oct 23 '12 at 10:55

score 2 · Answer 3 · answered Oct 23 '12 at 11:03

//You can do by this way also :

<script>
    var employees = { "accounting" : [   // accounting is an array in employees.
                                    { "firstName" : "John",  // First element
                                      "lastName"  : "Doe",
                                      "age"       : 23 },

                                    { "firstName" : "Mary",  // Second Element
                                      "lastName"  : "Smith",
                                      "age"       : 32 }
                                  ], // End "accounting" array.                                  
                  "sales"       : [ // Sales is another array in employees.
                                    { "firstName" : "Sally", // First Element
                                      "lastName"  : "Green",
                                      "age"       : 27 },

                                    { "firstName" : "Jim",   // Second Element
                                      "lastName"  : "Galley",
                                      "age"       : 41 }
                                  ] // End "sales" Array.
                } // End Employees


    var output="<ul>";
    for (var i in employees.accounting) {
        output+="<li>" + employees.accounting[i].firstName + " " + employees.accounting[i].lastName + "--" + employees.accounting[i].age+"</li>";
    }
    output+="</ul>";

    var output1="<ul>";
    for (var j in employees.sales) {
        output1+="<li>" + employees.sales[j].firstName + " " + employees.sales[j].lastName + "--" + employees.sales[j].age+"</li>";
    }
    output+="</ul>";

    alert(output1);

</script>

i want that parsing takes "sales" or "accounting" itself. any idea..? — Rikin Thakkar, Oct 23 '12 at 11:19
coz its possible that may be hundreds of names like "sales" and "accounting". what to do..? — Rikin Thakkar, Oct 23 '12 at 11:20

score 0 · Answer 4 · answered Oct 23 '12 at 10:59

The problem might have been due to line ending.

Here is a working[tested in chrome dev console] code:

var jsonStr = '{"1":\
    [\
        {"OrderItemId":832,"ItemId":995,"Price":0},\
        {"OrderItemId":833,"ItemId":997,"Price":0},\
        {"OrderItemId":834,"ItemId":999,"Price":0}\
    ],\
    "2":\
    [\
        {"OrderItemId":835,"ItemId":1008,"Price":0},\
        {"OrderItemId":836,"ItemId":1057,"Price":0}\
    ]\
}';
var obj = JSON.parse(jsonStr); // works!

i have applied "\" for line ending. – Rikin Thakkar Oct 23 '12 at 11:02 — Rikin Thakkar, Oct 23 '12 at 11:02

score 0 · Answer 5 · edited May 23 '17 at 11:48

0

You can use jQuery to Parse JSON

Also have a look at this SO question Parse JSON in JavaScript?

edited May 23 '17 at 11:48

Community

1
1

answered Oct 23 '12 at 11:01

Arun

3,440
11
60
108

score 0 · Answer 6 · answered Oct 23 '12 at 11:26

0

There is no need to add backward slashes after ending if every object item. You can separate with comma only.

answered Oct 23 '12 at 11:26

chirag

21
1

How to parse this type of string using javascript or jquery?

6 Answers6