How to remove item from an array in PowerShell (v5.1)

Question

I have an array of elements in PowerShell (v5.1) as below.

I want to remove the item with matching condition EmpId=102

$testData = @(
   @{ Name='ABC'; EmpId=100  },
   @{ Name='EFG'; EmpId=101 },
   @{ Name='XYZ'; EmpId=102 }
);

Is there any simple way to achieve this?

maybe something like $testData.Remove($testData.Find("EmpId == 102")) ?

is your actual array filled with hashtable items?

Lee_Dailey
– Lee_Dailey

2019-12-11 14:47:00 +00:00
Commented Dec 11, 2019 at 14:47 — Lee_Dailey
– Lee_Dailey, Commented Dec 11, 2019 at 14:47

Lee_Dailey · Accepted Answer · 2019-12-11 15:36:29Z

2

if your array is really a collection of one-item hashtables, then the following otta work ... [grin] it pipes the collection thru the Where-Object cmdlet & filters out anything item that has the value-to-exclude in the EmpId key value.

$TestData = @(
    @{ Name='ABC'; EmpId=100  }
    @{ Name='EFG'; EmpId=101 }
    @{ Name='XYZ'; EmpId=102 }
    )
$EmpId_ToExclude = 102

$TestData |
    Where-Object {
        $_['EmpId'] -ne $EmpId_ToExclude
        }

output ...

Name                           Value
----                           -----
EmpId                          100
Name                           ABC
EmpId                          101
Name                           EFG

note that the items are not required to be in order ... that is how hashtables work if you don't specify [ordered].

edited Dec 11, 2019 at 15:36

answered Dec 11, 2019 at 14:54

Lee_Dailey

7,5292 gold badges25 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

js2010 · Accepted Answer · 2019-12-11 16:32:31Z

2

I hope this info is some use. Maybe you can use an arraylist. You don't need @( ) to make an array.

[collections.arraylist]$testData = @{ Name='ABC'; EmpId=100  },
  @{ Name='EFG'; EmpId=101 },
  @{ Name='XYZ'; EmpId=102 }

$a = $testdata[1]
$testdata.remove($a)

Or

$testdata.removeat(1)

Unfortunely, this doesn't work. I guess you would need a pointer to the hashtable:

$testdata.remove(@{ Name='XYZ'; EmpId=102 })

Actually, it would be easy with a single hashtable:

$testData = @{ 'ABC'=100  
  'EFG'=101
  'XYZ'=102 }

$testdata.remove('xyz')

$testdata

Name                           Value
----                           -----
ABC                            100
EFG                            101

edited Dec 11, 2019 at 16:32

answered Dec 11, 2019 at 16:21

js2010

28.3k6 gold badges82 silver badges87 bronze badges

Collectives™ on Stack Overflow

How to remove item from an array in PowerShell (v5.1)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related