Skip to content

Instantly share code, notes, and snippets.

@takashiski
Created December 17, 2016 18:03
Show Gist options
  • Save takashiski/6e4984993df2af185d93ffb318e29309 to your computer and use it in GitHub Desktop.
Save takashiski/6e4984993df2af185d93ffb318e29309 to your computer and use it in GitHub Desktop.
convert JSON array to csv.
module.exports = function(jsonArray)
{
var json = jsonArray[0];
var keys = [];
for(var key in json)
{
keys.push(key);
}
var csv = "";
for(var i=0;i<keys.length;i+=1)
{
var key = keys[i];
csv += key;
if(i+1<keys.length)
{
csv +=",";
}
csv += "\n";
}
for(var i=0;i<jsonArray.length;i+=1)
{
var json = jsonArray[i];
for(var j=0;j<keys.length;j+=1)
{
var d = json[keys[j]];
csv += d;
if(j<keys.length)
{
csv += ",";
}
}
csv += "\n";
}
return csv;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment