Convert JSON data to two dimensional Array

Question

JSON Data sample:

 { 
        "GroupA": "Array[37]", 
        "AGroupC": "Array[9]", 
        "GroupB": "Array[12]", 
        "GroupE": "Array[15]", 
        "GroupF": "Array[21]", 
        "GroupD": "Array[6]" 
        }

I have the above data and I need to convert it to two dimensional array but don't know how to do it. Any help will be appreciated. The resulting should look like:

["GroupA", "GroupC", "AGroupB", "GroupE", "GroupF", "GroupD"]
[37, 9, 12, 15, 21, 6]

Thanks.

It's a little unclear what the original JSON has... Is it an array that contains only the single numbers specified? — Sahar Zehavi
– Sahar Zehavi, Commented Sep 21, 2015 at 19:47
You want to convert it then to [ [ key1, key2, ... , keyN ], [ key1.length, key2.length, ... , keyN.length] ] that is all that I'm able to gather from your representation — fi0rini
– fi0rini, Commented Sep 21, 2015 at 19:48

Rayon · Accepted Answer · 2015-09-21 20:04:43Z

1

Try this:

var dataJson = {
  "GroupA": "Array[37]",
  "AGroupC": "Array[9]",
  "GroupB": "Array[12]",
  "GroupE": "Array[15]",
  "GroupF": "Array[21]",
  "GroupD": "Array[6]"
};

var groupArr = [];
var arrayArr = [];

for (var i in dataJson) {
  if (dataJson.hasOwnProperty(i)) {
    groupArr.push(i);
    arrayArr.push(dataJson[i].match(/\d+/)[0]);
  }
}
alert('groupArr: ' + JSON.stringify(groupArr));
alert('arrayArr: ' + JSON.stringify(arrayArr));

answered Sep 21, 2015 at 20:04

Rayon

36.6k5 gold badges54 silver badges78 bronze badges

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

1 Comment

EBamba Over a year ago

Thanks Rayon, this gives back the format I was looking for.

fi0rini · Accepted Answer · 2015-09-21 19:56:28Z

0

From what I can tell, this is what you are asking for.

function convertJSONto2D(json) {
    var 2dArray = [];
    var result  = [];

    2dArray.push(Object.keys(json));

    for(key in json) {
        if (object.hasOwnProperty(key)) {
            result.push(json[key].length);
        }
    }

    2dArray.push(result);

    return 2dArray;
}

answered Sep 21, 2015 at 19:56

fi0rini

1,1981 gold badge14 silver badges17 bronze badges

Comments

Leo · Accepted Answer · 2015-09-21 20:54:50Z

0

Try sometihing like this:

    var dataJson = { 
            "GroupA": "Array[37]", 
            "AGroupC": "Array[9]", 
            "GroupB": "Array[12]", 
            "GroupE": "Array[15]", 
            "GroupF": "Array[21]", 
            "GroupD": "Array[6]" 
            }


    var groupArr = [];
    var arrayArr = [];

    function dataArr() {

        for (i = 0; i < (dataJson.length); i++) {
            groupArr.push(dataJson[i+i]);
            arrayArr.push(dataJson[i+1]);
        }   
    }

//output of each:
//groupArr
// ["GroupA", "GroupC", "AGroupB", "GroupE", "GroupF", "GroupD"]
//arrayArr
// ["Array[37]", "Array[9]", "Array[12]", "Array[15]", "Array[21]", "Array[6]"]

edited Sep 21, 2015 at 20:54

answered Sep 21, 2015 at 19:56

Leo

6752 gold badges9 silver badges25 bronze badges

Collectives™ on Stack Overflow

Convert JSON data to two dimensional Array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related