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

[whlavina]

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]

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.