How to convert Json string with key-value pair into string with only values in javascript

Question

How to convert JSON string with key-value pair into string with only values in javascript.

For example my JSON output looks like this

{
  "data": {
    "BearCollection": {
      "BearDetails": [
        {
          "Name": "James",
          "x": "81.43410000",
          "y": "6.32813300"
        },
        {
          "Name": "James",
          "x": "81.43489000",
          "y": "6.32763300"
        },
        {
          "Name": "Sera",
          "x": "81.4377000",
          "y": "6.32453300"
        }
      ]
    }
  },
  "xhr": {}
}

I want to convert it using javascript as

var details=[
  [
    "James",
    81.4341,
    6.328133
  ],
  [
    "James",
    81.43489,
    6.327633
  ],
  [
    "Sera",
    81.4377,
    6.324533
  ]
];

Is there any way to do this?

Use JSON.parse(); and iterate through the json objects and build the required data. — Latheesan
– Latheesan, Commented Mar 28, 2014 at 9:41

Joakim M · Accepted Answer · 2014-03-28 10:18:05Z

1

var json = "Your JSON string";
obj = JSON.parse(json);

for(int i= 0; i< obj.data.BearCollection.BearDetails.length;i++)
{
   String Name = obj.data.BearCollection.BearDetails[i].Name;
   String x = obj.data.BearCollection.BearDetails[i].x;
   String y = obj.data.BearCollection.BearDetails[i].y;

  ..fill Array (pseudo - do some work yourself ;) )
}

edited Mar 28, 2014 at 10:18

answered Mar 28, 2014 at 9:58

Joakim M

1,8032 gold badges15 silver badges29 bronze badges

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

4 Comments

Bergi Over a year ago

the question asked for JavaScript?

Joakim M Over a year ago

@Bergi and the code above is? (Except for som pseudo)

Joakim M Over a year ago

StackOverflow is in my eyes help to help yourself. Not to get complete solutions. But that's my opinion.

Bergi Over a year ago

Nothing wrong with that, but you might should have stated that. Especially the type annotations confused me, and …fill Array should be marked as a comment

Bergi · Accepted Answer · 2014-03-28 10:16:10Z

0

Use JSON.parse to get the object from the JSON string, then access the BearDetails, convert each element to an array, and stringify the new collection again:

var obj = JSON.parse(jsonstring);
var details = obj.data.BearCollection.BearDetails.map(function(detail) {
    return [detail.Name, detail.x, detail.y];
});
return JSON.stringify(details);

answered Mar 28, 2014 at 10:16

Bergi

671k162 gold badges1k silver badges1.5k bronze badges

Comments

Gert Arnold · Accepted Answer · 2024-08-16 20:28:49Z

0

$(document).ready(function() {
var data = JSON.parse('{"data": {"BearCollection": {"BearDetails": [{"Name": "James","x": "81.43410000","y": "6.32813300"},{"Name": "James","x": "81.43489000","y": "6.32763300"},{"Name": "Sera","x": "81.4377000","y": "6.32453300"}]}},"xhr": {}}');

var bear;
var arr = [];
var nestedArr;
for (i in data.data.BearCollection.BearDetails) {
    bear = data.data.BearCollection.BearDetails[i];

    nestedArr = [];
    nestedArr.push(bear.Name);
    nestedArr.push(bear.x);
    nestedArr.push(bear.y);

    arr.push(nestedArr);
}

});

edited Aug 16, 2024 at 20:28

Gert Arnold

110k36 gold badges218 silver badges319 bronze badges

answered Mar 28, 2014 at 10:04

Emanuele Ciriachi

2,2742 gold badges29 silver badges44 bronze badges

1 Comment

Bergi Over a year ago

Have a look at Why is using “for…in” with array iteration such a bad idea?

Collectives™ on Stack Overflow

How to convert Json string with key-value pair into string with only values in javascript

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related