how to change the below format to json format using javascript

Question

I want to convert this data format:

"color;blue:36 ,red:27"

to the following JSON format:

{
  "Record": [
    {
      "type": "color",
      "data": "blue",
      "total": "36"
    },
    {
      "type": "color",
      "data": "red",
      "total": "27"
    }
  ]
}

is color;blue:36 ,red:27 really the format you want to convert? — Nina Scholz
– Nina Scholz, Commented Nov 20, 2016 at 18:24
yes..i get data in this format and im looking to convert it to the above format.. — Deepak Desai
– Deepak Desai, Commented Nov 20, 2016 at 18:31

Alexey Soshin · Accepted Answer · 2016-11-20 18:35:38Z

1

It's hard to understand the exact problem with the given input, but that should suffice:

    var input = "color;blue:36 ,red:27";

    // Reassignment is bad, but will shorten the example
    input = input.split(";");

    var attributeName = input[0];

    // No length validations, also bad
    var attributes = input[1].split(",");

    var results = {"Record": attributes.map(function(a) {
        a = a.split(":");
        return {"type":attributeName,
            "data":a[0].trim(),
            "total": a[1].trim()}
    })};

    console.log(results)

answered Nov 20, 2016 at 18:35

Alexey Soshin

17.9k2 gold badges37 silver badges42 bronze badges

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

1 Comment

Winter Soldier Over a year ago

Ah you won the race! :)

Nina Scholz · Accepted Answer · 2016-11-20 18:58:37Z

1

This proposal splits the string first by semicolon for getting the type and the data, delimited by ' ,'. Then split by colon for data and total.

var data = 'color;blue:36 ,red:27',
    parts = data.split(';'),
    object = {
        Record: parts[1].split(' ,').map(function (a) {
            var p = a.split(':');
            return { type: parts[0], data: p[0], total: p[1] };
        })
    };

console.log(object);

.as-console-wrapper { max-height: 100% !important; top: 0; }

edited Nov 20, 2016 at 18:58

answered Nov 20, 2016 at 18:19

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

1 Comment

Mahi Over a year ago

you gave answer and i didn't even understand question

Winter Soldier · Accepted Answer · 2016-11-20 18:38:18Z

0

Here is how I'd do it

var dataFormat = "color;blue:36 ,red:27"
var splitFormat = dataFormat.split(";");
var type = splitFormat[0];
var colors = splitFormat[1].split(",");
var results = [];
_.each(colors, function(color) {
console.log(color)  
  var obj = {
    "type": type,
    "data": color.split(":")[0],
    "total":color.split(":")[1]
  }
  results.push(obj);
});
var final = {
  "Result": results
};
$("#result").html(JSON.stringify(final));

<script src="https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.8.3/underscore-min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<div id="result"></div>

answered Nov 20, 2016 at 18:38

Winter Soldier

2,7033 gold badges16 silver badges18 bronze badges

Collectives™ on Stack Overflow

how to change the below format to json format using javascript

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related