bug#24527: Problem while sorting comma separated values using sort comma
From:
Jash Dave
Subject:
bug#24527: Problem while sorting comma separated values using sort command.
Date:
Sat, 24 Sep 2016 15:14:28 +0530
There is problem while sorting comma separated entries (specifically
numbers). Even when the separator symbol is set to comma, it reads all
following columns with numbers, and doesn't treats comma as separator
between following numbers.
If I use command:
sort -t"," -k1 -n Example.csv
Example.csv :
1,100,a,1,a
4,1000,d,4,c
3,1002,c,3,c
22,10,a,2,b
Output:
1,100,a,1,a
22,10,a,2,b
3,1002,c,3,c
4,1000,d,4,c
Expected:
1,100,a,1,a
3,1002,c,3,c
4,1000,d,4,c
22,10,a,2,b
But it works with column 2 or 4, since there are no following numbers.
Regards,
Jash Dave.