Powershell - Filter a flat Array with a flat Array without ForEach

Question

Have a simple array of serial numbers, $arySerials. I use them to make a web services call. The web service API only accepts 50 serial numbers at a time. So, I want to send 50 from $arySerials, then remove those 50 from the original array with the working array $arySerialsWorking. Without iterating through a ForEach.

while ($arySerialNumbers.count -ne 0)
{
     $arySerialsWorking = $arySerialNumbers[0..49]
     $strSerialsWorkingOut = $arySerialsWorking -join ","
     $objOutContractInformationArray += Get-ASContractInformation -arySerialNumbers $strSerialsWorkingOut
     $arySerialNumbers = $arySerialNumbers | where {$_ -ne $arySerialsWorking }

}

I want:

$arySerialNumbers = $arySerialNumbers | where {$_ -ne $arySerialsWorking }

To remove the already used serial numbers. Until eventually $arySerialNumbers.count will end up at 0. I want to do this without doing a long ForEach Itteration.

Since an array object is of fixed size, you can't remove items. You can filter the array and set the result to a new array. You can also cast the array to a different type that supports removal like [system.collections.arraylist]. You could alternatively use a for loop and increment your index by 50 on each end of the range for each iteration. — AdminOfThings
– AdminOfThings, Commented Sep 10, 2019 at 18:05

AdminOfThings · Accepted Answer · 2019-09-10 19:15:28Z

1

You could do the following to produce the desired effect.

$objOutContractInformationArray = for ($i = 0; $i -lt $arySerialNumbers.count; $i += 50) {
    $arySerialsWorking = $arySerialNumbers[$i..($i+49)]
    $strSerialsWorkingOut = $arySerialsWorking -join ","
    Get-ASContractInformation -arySerialNumbers $strSerialsWorkingOut
}

edited Sep 10, 2019 at 19:15

answered Sep 10, 2019 at 18:14

AdminOfThings

25.2k4 gold badges22 silver badges30 bronze badges

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

5 Comments

Chris Shockey Over a year ago

This is perfect. I really appreciate it. I wish my upvote counted!

Chris Shockey Over a year ago

You mind adding a "+=" instead of an "=" on line 4 to make it correct.

AdminOfThings Over a year ago

Sure. Do note that += to rebuild arrays is not ideal or efficient. Doing that requires having to expand the array every time that operation occurs. You are better off outputting your command in the loop and setting the entire loop output to your array. An example would be $objOutContractInfoArray = for () { Get-AsContractInformation }

AdminOfThings Over a year ago

I have updated the post to do the array build more efficiently. Let me know if that works.

Chris Shockey Over a year ago

I had no idea you could do that. Thanks for taking the time to show me. I've implemented your solution, works like a champ. (Just need to change my typo of "$arySerialsWorkingOut " to "$strSerialsWorkingOut ".

Collectives™ on Stack Overflow

Powershell - Filter a flat Array with a flat Array without ForEach

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related