Convert HTML Table into JSON and set new key to JSON

Question

I want to convert the data of a html table into json set its key.

var tbl = $('#table-availed-prod tr').map(function () { return $(this).find('td').map(function () { return $(this).html(); }).get(); }).get();

What I get is this

JSON :

OR

Array(){ 0: "Sophos" 1: "Complementary" 2: "Codey Ropen" }

What I need is something like this

JSON :

[{ Productname:"Sophos", ProductTypename:"Software", AssignedPerson:"Codey" }, { Productname:"Sophos", ProductTypename:"Software", AssignedPerson:"Codey" }, { Productname:"Sophos", ProductTypename:"Software", AssignedPerson:"Codey" }]

My Table:

Similar question is answered here

karthickj25
– karthickj25

2019-03-20 04:57:44 +00:00
Commented Mar 20, 2019 at 4:57 — karthickj25
– karthickj25, Commented Mar 20, 2019 at 4:57

Prabu samvel · Accepted Answer · 2019-03-20 05:32:12Z

Try this approach.

var arr1 = []; var carr = ['product name', 'product type', 'assigned person']; $("#table-availed-prod tr").map(function(i, tr){	var arr = {};	$(this).find('td').map(function(j, td){ if(carr.indexOf(j) !== -1){	arr[carr[j]] = $(this).text();	}	});	arr1.push(arr); }); console.log(arr1);

Collectives™ on Stack Overflow

Convert HTML Table into JSON and set new key to JSON

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related