I've got a comma-separated file that looks like this:
100,00869184
6492,8361
1234,31
200,04071
I want to use sort
to sort this file numerically by the first column only.
Desired Result:
100,00869184
200,04071
1234,31
6492,8361
How do I achieve this using sort? It seems like the commas are being treated like thousands separators instead of delimiters even when I call them out as such.
Both sort -t',' -n
and sort -t',' -nk1'
give me this:
1234,31
200,04071
6492,8361
100,00869184
Sorting by the default (no parameters) or using sort -t','
gives me this:
100,00869184
1234,31
200,04071
6492,8361
And sorting as a number sort -n
gives me this:
1234,31
200,04071
6492,8361
100,00869184
How can I use sort to achieve my desired result?
Edited to add: This is for a one-time operation to create a sorted list of about 7 million lines, so workarounds or other unorthodox methods are perfectly acceptable.
-t
option as having a space between the-t
and the character