Convert a table array to JSON object

Question

I am working on a function for converting a table array to JSON and this is my code. I have checked strJSON is the JSON format I want, but it is a string instead of an JSON object. An error message prompts out saying that "Darren is not defined" when I try to convert it into JSON with "eval". I dont know what is happening.

var myArray=[["Name","Age","Gender"],["Darren",31,"Male"],["Gakki",25,"Female"]];

//expected output
var myJSON=[{"Name":"Darren","Age":31,"Gender":"Male"},{"Name":"Gakki","Age":25,"Gender":"Female"}];

function convertJSON(tableData){
    var objJSON=[];
    var strJSON=[];
    tableData.forEach(function(rowData,i){
        if (i==0){
            rowData.forEach(function(cellData){
                head.push(cellData);
            });
        }
        else{
            var objData=[];
            var objEntry=[];
            rowData.forEach(function(cellData,j){
                 objData=head[j] + ":" + cellData;
                objEntry.push(objData);
             });
            strJSON.push("{" + objEntry + "}");
        }
    });
    objJSON=eval("[" + strJSON + "]");
    return objJSON
}

You don't convert things into JSON with eval, you use JSON.parse and you don't even need to do that at this point since strJSON would be JSON already if you did it right. — A. L
– A. L, Commented May 17, 2017 at 6:13

tanmay · Accepted Answer · 2017-05-17 06:19:23Z

3

Get 1 element and remove it in original array by Array#shift
Then use Array#map to build your expect result

var myArray=[["Name","Age","Gender"],["Darren",31,"Male"],["Gakki",25,"Female"]];

var properties = myArray.shift();

var result = myArray.map( a => {
  var newObj = {};
  properties.forEach ( (p, idx) => {
    newObj[p] = a[idx];
  });
  return newObj;
})

console.log(result);

edited May 17, 2017 at 6:19

tanmay

7,9112 gold badges24 silver badges39 bronze badges

answered May 17, 2017 at 6:14

taile

2,77619 silver badges32 bronze badges

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

Comments

AndrewR · Accepted Answer · 2017-05-17 08:14:43Z

0

Don't try to create a JSON string manually. Put together a normal object and use JSON.stringify to convert.

var myArray=[["Name","Age","Gender"],["Darren",31,"Male"],["Gakki",25,"Female"]];

//expected output
var myJSON=[{"Name":"Darren","Age":31,"Gender":"Male"},{"Name":"Gakki","Age":25,"Gender":"Female"}];

function convertJSON(tableData){
    var keys = tableData[0],
        objects = [];
        
    for(var i = 1; i < tableData.length; i++){
        var rowObject = {};
        tableData[i].forEach(function(item, index){
            rowObject[keys[index]] = item;
        });
        objects.push(rowObject);
    }
    
    return JSON.stringify(objects);
}

document.write(convertJSON(myArray));

edited May 17, 2017 at 8:14

answered May 17, 2017 at 6:18

AndrewR

6,7781 gold badge26 silver badges38 bronze badges

2 Comments

mogcai Over a year ago

myArray is being modified after shift();, How to keep it unchange?

AndrewR Over a year ago

I edited the code so it doesn't need to call shift(), and leaves your original array intact.

Sampath Wijesinghe · Accepted Answer · 2017-05-17 06:16:38Z

0

    function html2json() {
   var json = '{';
   var otArr = [];
   var tbl2 = $('#dest_table tr').each(function(i) {        
      x = $(this).children();
      var itArr = [];
      x.each(function() {
         itArr.push('"' + $(this).text() + '"');
      });
      otArr.push('"' + i + '": [' + itArr.join(',') + ']');
   })
   json += otArr.join(",") + '}'

   return json;
}

answered May 17, 2017 at 6:16

Sampath Wijesinghe

6901 gold badge11 silver badges34 bronze badges

Collectives™ on Stack Overflow

Convert a table array to JSON object

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related