zemirco / json2csv

Convert json to csv with column titles
http://zemirco.github.io/json2csv
MIT License
2.72k stars 362 forks source link

how to use transform #577

Open mingxin-yang opened 2 years ago

mingxin-yang commented 2 years ago

I want to modify a csv file, add a status column, and add the corresponding data, but I can't use the following code, how can I modify it? went on

let path = __dirname + '/emails/' + value.filename + '.csv';

            const fields = ['email', 'fullname', 'status'];
            const opts = { fields, transform:[function (buf, enc, next) {
              return {
                ...buf,
                  email:job1.data.email,
                  fullname:job1.data.fullname,
                  status:value.status 
              }
            }]};
            const transformOpts = {objectMode: true};
            const json2csv = new Transform(opts, transformOpts);
            const input = fs.createReadStream(path, { encoding: 'utf8' });
            const output = fs.createWriteStream(path, { encoding: 'utf8' });

            const processor = input.pipe(json2csv).pipe(output);