csv-column-reorder

allows to rearrange the columns of csv files

Usage no npm install needed!

<script type="module">
  import csvColumnReorder from 'https://cdn.skypack.dev/csv-column-reorder';
</script>

README

Build Status npm version NPM

csv-column-reorder

I often receive large CSV files for importing to postgre databases. I often struggle with random column orders of the csv files. Therefore I descided to write this module and learn node by the way. This module allows to rearrange the columns of csv files, since tools like Excel struggle with large csv files.

usage:

var csv = require('csv-column-reorder');

var filePath = process.argv[2]; // path to your file
var newOrder = JSON.parse(process.argv[3]); //'{"0": 1, "1": 0}' will exchange the second column of a csv file with the first
var separator = process.argv[4]; // default is ';'

var callBack = function (err) {
    if (err) {
        console.log('something went wrong: '+err);
    } else {
        console.log('success');
    }
};
csv.reorder(filePath, newOrder, callBack,separator);

As this snippet is part of the starting point of the module it can be executed by command line.

running tests

I'm using mocha, proxyquire, mock-fs and sinon for my tests.