Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sort by mixed column types, some numeric and some non-numeric, some forward and some reverse #342

Open
whlavina opened this issue Apr 8, 2024 · 1 comment

Comments

@whlavina
Copy link

whlavina commented Apr 8, 2024

The sort command can sort lexicographically or numerically, optionally in reverse order, but this applies to all columns. It is not possible to sort by a compound key that mixes some columns of each type, some columns reversed.

A workaround is to use GNU sort, which does have this feature, but unlike xsv tooling, it doesn't handle CSV format or column headers.

@janxkoci
Copy link

janxkoci commented Dec 28, 2024

Your can have a look at miller or csvtk which both allow sorting on multiple columns using different criteria. Especially miller is very robust and useful tool 😉

PS: both are written in Go and very fast, although not as fast as xsv.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants