CSVLint
CSVLint copied to clipboard
Request: Sort by Column(s)
Apologies in advance if entering a request as an "issue" is bad manners - I could not see anywhere else to do this. This is a really useful plug-in for quickly inspecting CSV files for issues (especially trailing zeros that excel always hides/ignores). It would be awesome if you could add the below to your to-do list...
- Sort by data by one or more Column(s)
Thanks! TEG
Thanks for the feedback, sorting is certainly a feature I want to add. But I want to do it by updating the "reformat data" more broadly, like move columns around, sort, and maybe even filter or join two datasets.
The latest release 0.4.6 has a new "Sort Data" feature, it can sort the data ascending or descending on a single column. It takes into account the data type, meaning it will sort datetime, integer and decimals on actual values instead of sorting alphabetically.
Although it can only sort on a single column, it's at least better than having no sorting option. See the documentation for a work-around by sorting multiple times.