多字段（数字或字符串）排序的问题？？？

lkk2003rty

回复 9# ywlscpl


    弱弱的问一下  为什么前面要有LANG=C 这个有什么作用？

lkk2003rty

回复 10# gnubuntu


    转成大写后用9楼的  俺错了。。。。sorry。。。。

iori809

awk -F"|" '{print $NF" "system("date -d "$1 $2 $3" +%s")}' linux.156 | sed 'N;s/\n/|/' | sort -n | awk -F"|" '{print strftime("%d|%b|%Y",$1)" "$2}'
12|May|2000 Birth Control Pill Sparked Contraceptive Revolution 0
28|May|2000 Bluegrass Jam Sessions Popular Across United States 0
01|Jun|2000 Egypt Opens Border With Gaza Strip to Allow Humanitarian Aid 0
24|May|2007 Arturo Sandoval Slows the Pace on 'A Time For Love' 0
19|May|2008 Sahel Food Security Depends on Reinvesting in Local Agriculture 0
19|May|2008 UN Looking for Ways to Keep Girls in School 0
24|May|2009 Most Powerful Woman in American History? 0
13|May|2010 Britain's New Cabinet Holds First Meeting to Tackle Deficit 0
13|May|2010 Niger Faces Severe Food Shortages 0
14|May|2010 Anti-Incumbent Winds Blowing in Advance of 2010 Elections 0
14|May|2010 Thai Protest Leaders Press for Ceasefire as Deadly Clashes Continue 0
15|May|2010 Gulf Oil Spill Presents New Challenges to Vietnamese Fishermen in L 0
19|May|2010 Study Urges US to Push Mideast Allies Toward Democracy 0
20|May|2010 Farming has Superstars, Too 0
25|May|2010 US Sees Progress in Economy Talks with China 0
27|May|2010 Oil Spill Sparks Concerns About Imported Seafood 0
28|May|2010 Flotilla Challenges Israeli Blockade of Gaza 0
28|May|2010 NATO Prepares to Test President Obama's 'Surge' Strategy in Afgh 0
28|May|2010 Studies Find Increasing Health Benefits From Vitamin D 0
01|Jun|2010 Ethiopian Opposition Coalition Calls for New Vote 0

写了一个很难看的~只能代表一种思路跟大家分享一下哈哈。效率太差了

l_penny

1. [root@server ~]# sort -t"|" -k3n -k2M -k1  urfile  

复制代码

12|May|2000|Birth Control Pill Sparked Contraceptive Revolution
28|May|2000|Bluegrass Jam Sessions Popular Across United States
01|June|2000|Egypt Opens Border With Gaza Strip to Allow Humanitarian Aid
24|May|2007|Arturo Sandoval Slows the Pace on 'A Time For Love'
19|May|2008|Sahel Food Security Depends on Reinvesting in Local Agriculture
19|May|2008|UN Looking for Ways to Keep Girls in School
24|May|2009|Most Powerful Woman in American History?
13|May|2010|Britain's New Cabinet Holds First Meeting to Tackle Deficit
13|May|2010|Niger Faces Severe Food Shortages
14|May|2010|Anti-Incumbent Winds Blowing in Advance of 2010 Elections
14|May|2010|Thai Protest Leaders Press for Ceasefire as Deadly Clashes Continue
15|May|2010|Gulf Oil Spill Presents New Challenges to Vietnamese Fishermen in L
19|May|2010|Study Urges US to Push Mideast Allies Toward Democracy
20|May|2010|Farming has Superstars, Too
25|May|2010|US Sees Progress in Economy Talks with China
27|May|2010|Oil Spill Sparks Concerns About Imported Seafood
28|May|2010|Flotilla Challenges Israeli Blockade of Gaza
28|May|2010|NATO Prepares to Test President Obama's 'Surge' Strategy in Afgh
28|May|2010|Studies Find Increasing Health Benefits From Vitamin D
01|June|2010|Ethiopian Opposition Coalition Calls for New Vote

ywlscpl

回复  ywlscpl


    开始的LANG=C 是什么？也不用 ; 隔开吗？这个是什么来的？


--month-sort 字段 ...
gnubuntu 发表于 2010-06-05 14:36

    "VAR=value command"这样的形式是将VAR作为一个环境变量传给命令command，但VAR=value对当前shell不产生影响

LANG是系统环境变量，用来设置系统语言。C代表英文环境，ASCII 编码
LANG的设置会对sort结果产生影响，LANG=C设置后sort按ASCII 编码排序

heqingbluesky

sort -t "|" -k3,3 -k2,2M -k1,1 testfile.txt