* ソート - Sort-Object [#v0574833]
** 前提 [#o394feba]
*** 1.csv: [#be19d2da]
name,id1,id2
A,1,100
B,2,20
X,10,100
A,3,100
** ソート [#gde8fb37]
** 辞書順 [#gde8fb37]
import-csv 1.csv | sort name | ft -auto
name id1 id2
---- --- ---
A 3 100
A 1 100
B 2 20
X 10 100
** 数値順 [#v76aa796]
import-csv 1.csv | sort {[int]$_.id1},{[int]$_.id2} | ft -auto
name id1 id2
---- --- ---
A 1 100
B 2 20
A 3 100
X 10 100
** 昇順・降順 [#id48cc93]
*** 昇順 [#ied7e837]
import-csv 1.csv | sort name | ft -auto
name id1 id2
---- --- ---
A 3 100
A 1 100
B 2 20
X 10 100
既定では昇順でソートする。
*** 降順 [#xab3a2aa]
import-csv 1.csv | sort -descending name | ft -auto
name id1 id2
---- --- ---
X 10 100
B 2 20
A 3 100
A 1 100
*** 昇順・降順組み合わせ [#hbee53d6]
import-csv 1.csv | sort @{Expression="name";Descending=$true}, @{Expression={[int]$_.id1};Ascending=$true} | ft -auto
name id1 id2
---- --- ---
X 10 100
B 2 20
A 1 100
A 3 100
** 参考 [#b66423e5]
- http://technet.microsoft.com/ja-jp/library/dd347688
- http://powershell.com/cs/blogs/ebookv2/archive/2012/03/12/chapter-5-the-powershell-pipeline.aspx
