New cmdlets in CPolydorou.General v2.9.0

There is a newer version of my CPolydorou.General PowerShell module that contains two new cmdlets, Remove-Duplicate and Compare-ObjectByProperty.

Let me guide you through the usage of these cmdlets.

We'll start with Compare-ObjectByProperty. This cmdlet compares two objects using the values on their properties. Let's take the following csv file as example:

Property1Property2Property3
abc
abd
efg
efg

Using the Import-Csv cmdlet we are going to save it to the "data" variable for later use:

PS C:\> $data = Import-Csv -Path .\data.csv

PS C:\> $data

Property1 Property2 Property3
--------- --------- ---------
a         b         c
a         b         d
e         f         g
e         f         g

If we compare the third and the fourth object using the "-eq" operator we get that the objects are not equal which is correct since those are different objects.

PS C:\> $data[2] -eq $data[3]
False

However, this is not what we are looking for. Since the properties on the objects have the same values, we would like to objects to be equal. Using the Compare-ObjectByProperty we are going to compare the values of the properties of the objects:

PS C:\> Compare-ObjectByProperty -ReferenceObject $data[2] -DifferenceObject $data[3]
True

Let's move on to the Remove-Duplicate. This cmdlet removes the duplicates objects from collections. Again, let's take for example the data in the same csv file. The third and fourth objects are the same so the latter should be removed:

PS C:\> $data | Remove-Duplicate

Property1 Property2 Property3
--------- --------- ---------
a         b         c
a         b         d
e         f         g

Wait, that's not all, we can also compare objects using a subset of their properties. the first and the second object have the same values on the first two properties, thus should be considered duplicates. Same thing with the third and fourth object.

PS C:\> $data | Remove-Duplicate -Property Property1,Property2

Property1 Property2 Property3
--------- --------- ---------
a         b         c
e         f         g

The module is available on the PowerShell Gallery as always.

I hope you'll find these cmdlets helpful, have fun!

Popular posts from this blog

Syslog Message Collection for OMS from sources that do not support the agent

How to Configure Message Forwarding on a Mailbox Level

Generating Alerts On OMS