Skip to content

Instantly share code, notes, and snippets.

@awinogradov
Created March 19, 2016 15:32
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save awinogradov/868a5125d3b948f891cf to your computer and use it in GitHub Desktop.
Save awinogradov/868a5125d3b948f891cf to your computer and use it in GitHub Desktop.
Remove one csv from another and generate new csv
const fs = require('fs');
const parse = require('csv-parse');
const all = fs.readFileSync('./all.csv');
const confirm = fs.readFileSync('./confirm.csv');
parse(all, {}, (err, allMembers) => {
parse(confirm, {}, (err, confirmedMembers) => {
const confirmedMembersEmails = {};
confirmedMembers.forEach(member => {
confirmedMembersEmails[member[0]] = true;
});
const declineMembers = allMembers.filter((member) => {
return !confirmedMembersEmails[member[0]];
});
declineMembers = allMembers.map(member => (member.splice(4)));
var file = fs.createWriteStream('./decline.csv');
declineMembers.forEach((v) => {
file.write(v.join(',') + '\n');
});
file.end();
});
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment