§ Call on a file
sortcsv) appending your file name (with or without
$ csvsort YOURFILE.csv
$ csvsort -o YOURFILE.csv
$ csvsort --overwrite YOURFILE.csv
$ csvsort -v
$ csvsort --version
$ csvsort -h
$ csvsort --help
§ Or omit the file's name
It will let you pick a CSV:
$ csvsort # omit the file's name, but you can include -o/--overwrite flag
omit the file name and
csv-sort-cli will offer a list of CSV files in the current folder to choose from:
You can even try it without installing — use
$ npx csv-sort-cli YOURFILE.csv
§ What it does exactly
- It sorts CSV file rows to correspond to the double-entry bookkeeping principles:
Sometimes internet banking CSV's have rows in a wrong order, especially when entries are on the same date. This library helps to sort the rows in correct order.
- As a bonus, it will trim the empty columns/rows:
- Not to mention, the our custom CSV parser
csv-split-easyused here will ensure that all CSV cell contents are trimmed, and there are no empty rows between the content rows. It also accepts any commas as content if the cell is wrapped with a double quotes.
See it in the monorepo , on Sourcehut.
Copyright © 2010–2020 Roy Revelt and other contributors