Skip to content

Instantly share code, notes, and snippets.

@bengarvey
Created March 9, 2019 21:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bengarvey/b3c3a5e43d499d9cc1e2c60d15bf46f2 to your computer and use it in GitHub Desktop.
Save bengarvey/b3c3a5e43d499d9cc1e2c60d15bf46f2 to your computer and use it in GitHub Desktop.
Convert some text to csv
function toCsv(ob) {
var result = "";
Object.keys(ob).forEach( key => { result += `${ob[key]},` });
return result.substring(0, result.length - 1);
}
///// PASTE YOUR DATA HERE ///
var rawData = `(not set)
Member
someemail@email.com
8/23/17
Disabled
Moderated
(not set)
Member
someemail@email.com
10/29/15
No email
Moderated
(not set)
Member
someemail@email.com
2/6/17
Abridged
Moderated`;
joinedData = rawData.split("\n");
obData = [];
for(var i=0; i<joinedData.length; i+= 7) {
var ob = {
Name: joinedData[i],
Status: joinedData[i+1],
Email: joinedData[i+2],
"Date Joined": joinedData[i+3],
"Email Status": joinedData[i+4],
"Moderation Status": joinedData[i+5]
}
obData.push(ob);
}
var final = "";
obData.forEach( (ob) => { final += `${toCsv(ob)}\n` });
console.log(final);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment