InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 04:24:44 GMT20http://www.sqlservercentral.com/Forums/Topic1371080-1351-1.aspxSORRY: This should have been a new topic, reposting.Hi,I have 2 Array or ArrayList objects, with data like[code="vb"]$Results = New-Object system.Collections.ArrayList$Results.Add("IMP_Trn_Project_Agent_6,User1")$Results.Add("IMP_Trn_Project_Agent_6,User2")$Results.Add("IMP_Trn_Project_Agent_6,User3")$Remove = New-Object system.Collections.ArrayList$Remove.Add("User2")[/code]How can I efficiently remove from the first array all items containing the users in the 2nd array?PaulThu, 11 Oct 2012 07:56:13 GMTschleephttp://www.sqlservercentral.com/Forums/Topic1371080-1351-1.aspxThis may not be a complete answer (I don't think I'll be getting any bonus points), but I was able to get the proper output by adding -Property to the Sort.[code="plain"]$cAlphas | Sort-Object -Property alpha -Unique[/code]Wed, 10 Oct 2012 14:46:35 GMTjjtetzlohttp://www.sqlservercentral.com/Forums/Topic1371080-1351-1.aspxI [strike]want[/strike] need to understand why the code below returnsalpha ----- Y Can someone explain why I don't see alpha-----XYBonus points: if the last 2 lines are$cAlphas = $Objects | select alpha | Get-Unique$cAlphas why do I get alpha-----XThanks![code="VB"]$Objects = @()$Object = New-Object system.object$Object | Add-Member -Type NoteProperty -Name alpha -value "X"$Object | Add-Member -Type NoteProperty -Name Num -value "1"$Objects += $Object$Object = New-Object system.object$Object | Add-Member -Type NoteProperty -Name alpha -value "X"$Object | Add-Member -Type NoteProperty -Name Num -value "2"$Objects += $Object$Object = New-Object system.object$Object | Add-Member -Type NoteProperty -Name alpha -value "Y"$Object | Add-Member -Type NoteProperty -Name Num -value "1"$Objects += $Object$Object = New-Object system.object$Object | Add-Member -Type NoteProperty -Name alpha -value "Y"$Object | Add-Member -Type NoteProperty -Name Num -value "2"$Objects += $Object$cAlphas = $Objects | select alpha $cAlphas | Sort-Object -Unique[/code]Wed, 10 Oct 2012 12:36:59 GMTschleep