如何按照最后一列數(shù)字大小進行排序？

iocg

如何按照最后一列數(shù)量進行排序？
文本由兩部分組成，前面為數(shù)量不定的單詞，最后一列為金額（每三位以逗號隔開）
金額與單詞間是TAB字符

1. With The First Rectangle        194,000,000
   
2. So Next Continue        293,000,000
   
3. Future Sheet Of Paper        6,580,000
   
4. Aboard This Process 2010        400,000
   
5. 80 S Time Retract The Foot        12,400,000
   
6. Cardstock Via This Process        87,400,000
   
7. Moreover Stick Along With        15,000,000
   
8. Granted Corp        66,200,000
   
9. Sensors Have A Fixed        1,186,000,000
   
10. Reliable Circumstances Substitute        359,000,000
    
11. All Certainly        0
    
12. Of These Using Good A        1,143,000,000
    
13. Period Of Point        40,600,000
    
14. Inthat Would 5 Long Periods        219,000,000
    
15. Of Time More Than The Kind Alarm        12,400,000
    
16. The Actual Current Email        695,400,000
    
17. Address Contact Information Are        47,500,000
    
18. Not Authored Virtual Farmland        82,000
    
19. Prepared Among Asteric Need        560
    
20. Loads Of Ways To Do The Best        465,000
    
21. With The First Rect angle        178,000,000
    

復制代碼

歐陽西風

回復 1# iocg


    排序完以后還要保持數(shù)字之間以,分隔嗎？我寫了一個比較長的命令，希望有人能夠?qū)憘�更好一點兒的

1. sed 'h;s/.*\(\t.*\)/\1/;s/,//g;H;g;s/\n//' sort_by_last_number.txt  | sort -n -t $'\t' -k 3 |  sed 's/\(.*\t.*\)\t.*/\1/'

復制代碼

yinyuemi

awk 'BEGIN{cmd="sort -nr -k1,1";}{print gensub(/,/,"","g",$NF),$0|& cmd;}END{ close(cmd,"to");while(cmd|& getline){print gensub($1 FS,"",1)} ;close(cmd)}'

yestreenstars

這種問題，用excel做最方便了~

iocg

回復 4# yestreenstars


    少量的數(shù)據(jù)可以用Excel解決，不過我用2003最大只能支持65535行。

1. sed 's/\,//g' 1.txt | sort -t'        ' -n -k2

復制代碼

我現(xiàn)在用這種辦法，不過如果能將30000000轉(zhuǎn)為30,000,000形式就更好了。

    謝謝2樓和3樓，問題已解決啦~~

jason680

回復 1# iocg

$ awk '{k=$NF;gsub(",","",k);a[sprintf("%020d",k)]=$0}END{t=asorti(a,b);for(n=1;n<=t;n++)print a[b[n]]}' FILE
All Certainly        0
Prepared Among Asteric Need        560
Not Authored Virtual Farmland        82,000
Aboard This Process 2010        400,000
Loads Of Ways To Do The Best        465,000
Future Sheet Of Paper        6,580,000
Of Time More Than The Kind Alarm        12,400,000
Moreover Stick Along With        15,000,000
Period Of Point        40,600,000
Address Contact Information Are        47,500,000
Granted Corp        66,200,000
Cardstock Via This Process        87,400,000
With The First Rect angle        178,000,000
With The First Rectangle        194,000,000
Inthat Would 5 Long Periods        219,000,000
So Next Continue        293,000,000
Reliable Circumstances Substitute        359,000,000
The Actual Current Email        695,400,000
Of These Using Good A        1,143,000,000
Sensors Have A Fixed        1,186,000,000

   

q1208c

sed -e 's/   */#/g' file | sort -t '#' -nk3 | sed -e 's/#/    /g'