批处理之家 - Powered by Discuz! Board

标题: [转载代码] [PowerShell每日技巧]删除重复行(20140304) [打印本页]

作者: DAIC 时间: 2014-3-6 12:34 标题: [PowerShell每日技巧]删除重复行(20140304)

Sort-Object has an awesome feature: with the parameter -Unique, you can remove duplicates:

PS C:\> 1,3,2,3,2,1,2,3,4,7 | Sort-Object
1
1
2
2
2
3
3
3
4
7
PS C:\> 1,3,2,3,2,1,2,3,4,7 | Sort-Object -Unique
1
2
3
4
7

This can be applied to object results, as well. Check out this example: it will get you the latest 40 errors from your system event log:

Get-EventLog -LogName System -EntryType Error -Newest 40 | Sort-Object -Property InstanceID, Message | Out-GridView
复制代码

This may be perfectly fine, but depending on your event log, you may also get duplicate entries.
With -Unique, you can eliminate duplicates, based on multiple properties:

Get-EventLog -LogName System -EntryType Error -Newest 40 | Sort-Object -Property InstanceID, Message -Unique | Out-GridView
复制代码

You will no longer see more than one entry with the same InstanceID AND Message.
You can then sort the result again, to get back the chronological order:

Get-EventLog -LogName System -EntryType Error -Newest 40 | Sort-Object -Property InstanceID, Message -Unique | Sort-Object -Property TimeWritten -Descending | Out-GridView
复制代码

So bottom line is: Sort-Objects parameter -Unique can be applied to multiple properties at once.

http://powershell.com/cs/blogs/tips/archive/2014/03/04/eliminating-duplicates.aspx

作者: ivor 时间: 2014-3-6 15:43

如果翻译过来，我相信会有更多的人有兴趣看的时间更久。

作者: DAIC 时间: 2014-3-6 16:39

回复 2# ivor

没空

作者: sdjnms 时间: 2014-4-19 23:07

看来是个行家，我刚接触这一块，还得请您多支持呢！加我好友吧，657307291

作者: DAIC 时间: 2014-4-20 09:18

回复 4# sdjnms

不聊QQ，直接在论坛切磋吧。

作者: sdjnms 时间: 2014-4-20 20:01

回复 5# DAIC

你在线不啊？我这有个多行的word，现在想删除重复项，有什么号办法吗？能教教我吗？

作者: DAIC 时间: 2014-4-20 20:31

回复 6# sdjnms

word不是纯文本文件，不方便直接处理。

欢迎光临批处理之家 (http://bathome.net./)