Convert string csv in JSON to array variable

Question

I have the following JSON data:

[
    {
        "Title": "PAGE A",
        "Users": "USRA"
    },
    {
        "Title": "PAGE B",
        "Users": "USRA,USRB"
    }
]

What would be the best way to convert the fields with "," in to arrays? and get using javascript:

[
    {
        "Title": "PAGE A",
        "Users": "USRA"
    },
    {
        "Title": "PAGE B",
        "Users": ["USRA","USRB"]
    }
]

Take a look [here](http://stackoverflow.com/questions/20881213/converting-json-object-into-javascript-array) — AndreaM16, Nov 20 '15 at 13:34
You would need to make the first Users be `"Users": ["USRA"]`. — Karl Gjertsen, Nov 20 '15 at 13:35
Why on earth would you want an inconsistent data type? Make them all arrays, don't matter if they only have 1 element or not — musefan, Nov 20 '15 at 13:39

jeremija · Answer 1 · 2015-11-20T13:43:38.597

You could do:

data = [
    {
        "Title": "PAGE A",
        "Users": "USRA"
    },
    {
        "Title": "PAGE B",
        "Users": "USRA,USRB"
    }
]

data.forEach(function(item) {
    // the if clause keeps the single user outside of an array
    if (item.Users && item.Users.indexOf(',') >= 0) {
        item.Users = item.Users.split(',');
    }
})

In case you wish to keep a consistent data type (make the Users property always be an Array):

data.forEach(function(item) {
    item.Users = item.Users ? item.Users.split(',') : [];
})

score 1 · Answer 2 · answered Nov 20 '15 at 13:38

A simple for each with a split is all you need

var data = [
    {
        "Title": "PAGE A",
        "Users": "USRA"
    },
    {
        "Title": "PAGE B",
        "Users": "USRA,USRB"
    }
];

data.forEach( function (obj) {
    obj.Users = obj.Users.split(",");
});

Now if you really do not want that one to be an array, than you need to add an if check.

data.forEach( function (obj) {
    var parts = obj.Users.split(",");
    if(parts.length>1) {
        obj.Users = parts;
    }
});

score 0 · Accepted Answer · answered Nov 20 '15 at 13:42

Do something like this

var input = [
        {
            "Title": "PAGE A",
            "Users": "USRA"
        },
        {
            "Title": "PAGE B",
            "Users": "USRA,USRB"
        }
    ];

var output = [];

output = input.map(function(d){
      for (key in d){
        if (d[key].indexOf(',') !== -1){
          d[key] = d[key].split(',');
          }
      } 
     return d;

});

$('#result').html(JSON.stringify(output));

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

Thanks this is a great answer since it tests the "aaa, bbb" csv issue for all keys. — Gerrie van Wyk, Nov 20 '15 at 14:21

Convert string csv in JSON to array variable

3 Answers3