enrich-csv

adds extra columns to a csv file from another csv file

usage:

var enrichCSV = require( 'enrich-csv' ),
    options = {
        lookupCSV: 'path/to/file/containing/data/you/want/to/insert.csv', // the 'source' file
        filesToTransform: [ 'other/file/that/needs/extra/data.csv' ], // the 'dest' file(s)
        outputSuffix: '-modified', // suffix that gets added to output filename
        lookupField: 'id', // uses this field from 'source' file for looking up
        //lookupFieldDest: 'id', // uses this field from 'dest' file for looking up. optional.
        extraData: { // the data to add to the 'dest' file(s)
            //name: 'last name'//, // when you pass a string it takes the value from that column
            name: function( record ){
                //console.log( record );
                return ( record[ 'first name' ] + ' ' + record.infix + ' ' + record[ 'last name' ] ).replace( '  ', ' ' );
            }, // when you pass an object you get the whole row as an object and decide for yourself what you return
        }
    },
    callback = console.log.bind( console, 'done enriching' );


enrichCSV( options, callback );