如何按照最后一列数字大小进行排序？

iocg

如何按照最后一列数量进行排序？
文本由两部分组成，前面为数量不定的单词，最后一列为金额（每三位以逗号隔开）
金额与单词间是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


    排序完以后还要保持数字之间以,分隔吗？我写了一个比较长的命令，希望有人能够写个更好一点儿的

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


    少量的数据可以用Excel解决，不过我用2003最大只能支持65535行。

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

复制代码

我现在用这种办法，不过如果能将30000000转为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'