How to covert JSON data in separate arrays in javascript?

Question

My JSON data has following format :

[{"Name":"A","Id":"1"},{"Name":"B","Id":"2"},{"Name":"C","Id":"3"}]

How covert this into two separate arrays as Name[] and Id[] using JavaScript ? I need the data in the following manner:

Name[0] should be : "A"
Name[1] should be : "B" and so on ...

Ja͢ck · Accepted Answer · 2013-02-27 09:51:08Z

1

this should work, jsonArray is your JSON

var name = [], ids = [];
jsonArray.forEach(function(item){
  name.push(item.Name);
  ids.push(item.Id);
}

edited Feb 27, 2013 at 9:51

Ja͢ck

174k39 gold badges269 silver badges316 bronze badges

answered Feb 27, 2013 at 9:37

mr.VVoo

2,26620 silver badges30 bronze badges

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

6 Comments

user2109916 Over a year ago

Its not working for me.. The JSON data which I want to covert to arrays is actually in the xmlHttp.responseText (since m getting it from a web service)..

mr.VVoo Over a year ago

You wrote that your jsonData is in this format. so whats the format of your jsonData? if it is wrapped in xhr.resposneText you need to parse it as JSON or provide the code.

user2109916 Over a year ago

this is my script code : var Url = "some url"; var xmlHttp = null; xmlHttp = new XMLHttpRequest(); xmlHttp.open( "GET", Url, false ); xmlHttp.send( null ); alert(xmlHttp.responseText); the alert shows the mentioned data

mr.VVoo Over a year ago

Then you need to parse xmlHttp.responseText which is delivered as String. Within alert this is a String and not an array.

user2109916 Over a year ago

How do I do that? :( I am pretty new to java script.

|

Bergi · Accepted Answer · 2013-02-27 09:39:14Z

0

var data = [{"Name":"A","Id":"1"},{"Name":"B","Id":"2"},{"Name":"C","Id":"3"}];

var result = {};
for (var i=0; i<data.length; i++) {
    for (var key in data[i]) {
        var item = data[i][key];
        if (key in result)
            result[key].push(item);
        else
            result[key] = [item];
    }
}

result.Name // ["A","B","C"]
result.Id // ["1","2","3"]

answered Feb 27, 2013 at 9:39

Bergi

671k162 gold badges1k silver badges1.5k bronze badges

1 Comment

Ja͢ck Over a year ago

+1. The one who downvoted this probably doesn't understand generic solutions =p

wizztjh · Accepted Answer · 2013-02-27 10:16:34Z

0

You could use miso project if you are handling a lot of data with different source.

var ds = new Miso.Dataset({
  data: [ 
    { one : 1, two : 4, three : 7 },
    { one : 2, two : 5, three : 8 }
  ]
}).fetch({
  success: function() {
    log( this.column('one').data );
  }
});

http://misoproject.com/dataset/api.html#misodataset_i_fetch

answered Feb 27, 2013 at 10:16

wizztjh

7,0417 gold badges61 silver badges92 bronze badges

Collectives™ on Stack Overflow

How to covert JSON data in separate arrays in javascript?

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related