我尝试使用谷歌搜索其他内容,但似乎找不到答案。
"ColumnOne","ColumnTwo","ColumnThree"
"C1V1","C2V1","C3V1"
"C1V2","C2V2","C3V2"
"C1V2","C2V2","C3V2"
"C1V3","C2V3","C3V3"
$input = 'C:\Temp\test.csv'
$inputCsv = Import-Csv $input | Select-Object -Unique
$inputCsv | Export-Csv "$input-temp.csv" -NoTypeInformation
#Move-Item "$input-temp.csv" $input -Force
"ColumnOne","ColumnTwo","ColumnThree"
"C1V2","C2V2","C3V2"
"ColumnOne","ColumnTwo","ColumnThree"
"C1V1","C2V1","C3V1"
"C1V2","C2V2","C3V2"
"C1V3","C2V3","C3V3"
有没有办法做到这一点?
您需要使用Select-Object或Sort-Object来指定列名称,以获得唯一的结果。如果您也想排序,请尝试以下代码。如果您不想使用,请使用选择对象。
$input = 'C:\Temp\test.csv'
$inputCsv = Import-Csv $input | Sort-Object * -Unique
$inputCsv | Export-Csv "$input-temp.csv" -NoTypeInformation
您也可以在此处引用博客。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句