CSVLint icon indicating copy to clipboard operation
CSVLint copied to clipboard

Request: Sort by Column(s)

Open TeaEarlGrey opened this issue 2 years ago • 1 comments

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

TeaEarlGrey avatar Apr 16 '22 00:04 TeaEarlGrey

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.

BdR76 avatar Apr 17 '22 10:04 BdR76

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.

BdR76 avatar Oct 01 '22 16:10 BdR76