shell programming problem using sort

josesec · 06-26-2011, 03:18 PM

Code:

0000000   4   1   .   0       1   0   .   0       7  \n   3   9   .   0
0000020   0       -   0   .   1   0       2   8   .   0   0  \n   4   0
0000040   .   0   0       -   1   9   .   2   0       2   .   2   5  \n
0000060   4   1   .   0       2   0   .   0       1   0  \n   3   9   .
0000100   0   0       -   0   .   4   0       2   5   .   5   8  \n   3
0000120   9   .   0   0       -   0   .   2   0       2   6   .   7   2
0000140  \n   3   9   .   0   0       0   .   2   0       3   0   .   1
0000160   8  \n   4   0   .   0   0       -   1   9   .   1   0       2
0000200   .   1   6  \n   4   1   .   0       1   5   .   0       1   2
0000220  \n   3   9   .   0   0       -   0   .   3   0       2   6   .
0000240   9   8  \n   3   9   .   0   0       0   .   3   0       3   3
0000260   .   3   1  \n   3   9   .   0   0       0   .   0   0       2
0000300   6   .   7   8  \n   4   0   .   0   0       -   2   0   .   0
0000320   0       1   .   3   9  \n   4   0   .   0   0       -   1   9
0000340   .   0   0       2   .   0   5  \n   4   1   .   0       5   .
0000360   0       8  \n   4   0   .   0   0       -   9   .   9   0    
0000400   2   9   .   6   4  \n   3   9   .   0   0       0   .   1   0
0000420       2   8   .   1   3  \n   4   0   .   0   0       9   .   9
0000440   0       2   8   .   2   5
0000447

colucix · 06-26-2011, 04:04 PM

Quote:

Originally Posted by josesec

I have used the same matrix that you haved used in the last message and the result is that one:

41.0 5.0 8
41.0 10.0 7
41.0 15.0 12
41.0 20.0 10
40.00 -20.00 1.39
40.00 -19.00 2.05
40.00 -19.10 2.16
40.00 -19.20 2.25
40.00 -9.90 29.64
40.00 9.90 28.25
39.00 0.00 26.78
39.00 -0.10 28.00
39.00 0.10 28.13
39.00 -0.20 26.72
39.00 0.20 30.18
39.00 -0.30 26.98
39.00 0.30 33.31
39.00 -0.40 25.58

I have used sort -k1rn -k2n infile but I find still the problem with decimals (not well organized at all), I feel this must be a silly problem but I don't manage to fix it.

Thank you

The problem is simply that the minus sign is ignored and the fields are sorted numerically in respect of their absolute value. The solution may reside in your current locale settings. Please check them using the command:

Code:

locale

and post the output here. To be sure the file is sorted as desired, force the LC_COLLATE variable to be C or POSIX:

Code:

env LC_COLLATE=C sort -k1rn -k2n file

josesec · 06-26-2011, 05:01 PM

LANG=es_ES.utf8
LC_CTYPE="es_ES.utf8"
LC_NUMERIC="es_ES.utf8"
LC_TIME="es_ES.utf8"
LC_COLLATE="es_ES.utf8"
LC_MONETARY="es_ES.utf8"
LC_MESSAGES="es_ES.utf8"
LC_PAPER="es_ES.utf8"
LC_NAME="es_ES.utf8"
LC_ADDRESS="es_ES.utf8"
LC_TELEPHONE="es_ES.utf8"
LC_MEASUREMENT="es_ES.utf8"
LC_IDENTIFICATION="es_ES.utf8"
LC_ALL=

I have tried this: env LC_NUMERIC=C sort -k1rn -k2n infile

and that works perfectly, thank you very much!

colucix · 06-26-2011, 05:19 PM

Glad it works! And I tried LC_NUMERIC=es_ES.utf8 and it (doesn't) works as in your previous example. The same for it_IT.utf8. I don't know why, but negative numbers are treated in a different way by the latin locales.