I thought I remember reading that there is a text editor that exists for windows that allows the sorting of data, treating the csv/tsv similar to how it is treating when one sorts in excel.
Any pointer is appreciated it is driving me crazy.
Does it has to be a text editor? Or is a (portable) CSV/TSV editor also acceptable?
Here is a screenshot of its sort functions
I can't think of a Windows editor that does this internally but Vim or Emacs can do it via some external tools, if that might be useful to you? Dealing with a proper CSV file would be a bit complicated but, for the simple case of a file like this example:
... a Vim command to sort the file by the second field in each line would be:
This relies on having
For a proper CSV file, though, it would be necessary to parse the CSV fully to deal with quoted commas before sorting by this method, and then to put the fields back into order again.
An example of piping through