Powershell - Copy folders with names matching array

Question

Here's what I'm trying to accomplish

run sql query - result output to txt file
results of txt file to array
get child item- folders and files in the directory if the folder name matches a value from the array
copy items that are returned in step 3 to another directory

The problem I am having is filtering the items in the directory based on the values of the array

gci $sourcepath -recurse | where {$_.name -like $idlist} | Copy-Item -Destination $DestinationHistoryPath

What is $idlist? Please provide a minimal reproducible example. — zett42
– zett42, Commented Mar 23, 2021 at 23:17
I'll echo what @zett42 has said. I'll go one step further and ask if you've checked into the -in comparison? — Colyn1337
– Colyn1337, Commented Mar 23, 2021 at 23:23

Steven · Accepted Answer · 2021-03-23 23:23:27Z

1

I'm assuming you've already loaded up the array properly. You don't want the -like operator for this particular scenario. You are better off with -in or -Contains. Something like below may work:

Get-ChildItem $sourcepath -Recurse | 
Where-Object {$_.Name -in $idlist} | 
Copy-Item -Destination $DestinationHistoryPath

If you use contains you'll need to switch the operands like:

Get-ChildItem $sourcepath -recurse | 
Where-Object { $idlist -contains $_.Name } | 
Copy-Item -Destination $DestinationHistoryPath

answered Mar 23, 2021 at 23:23

Steven

7,1271 gold badge17 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Powershell - Copy folders with names matching array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related