Match file name and copy using PowerShell

Question

I am struggling to get this simple PowerShell script to work. I have googled, but I can't find the answer.

As you can see, I am specifying the source and destination location.

The $filedate variable is doing a dateadd to get yesterdays date as the filename contains the date.

The $filter variable has the string I am searching on, including the date part.

The Get-ChildItem command works on its own, but when I apply the filter it returns nothing. What am I missing to get this to work?

$source = "C:\MSSQL.1\Backup\"
$destination = "D:\MSSQL.2\Backup\"
$filedate = (get-date).AddDays(-1).tostring('yyyyMMdd')
$filter = "FULL_(local)_Product_" + $filedate + "*"
Get-ChildItem -Path $source -filter $filter | Copy-Item -Destination $destination

The simplest conclusion is that the filter doesn't match. Could you please edit your question to add the following: what the $filter string actually equals, and the name of one of the files it SHOULD match. — Andrew Shepherd
– Andrew Shepherd, Commented Jul 5, 2011 at 9:57
Works fine for me. What do you get with: gci $source "FULL_(local)_Product_*" — Shay Levy
– Shay Levy, Commented Jul 5, 2011 at 11:26

Enrico Campidoglio · Accepted Answer · 2011-07-05 10:07:01Z

23

Try filtering the list of files by using the Where-Object cmdlet and the -match operator:

$source = "C:\MSSQL.1\Backup\"
$destination = "D:\MSSQL.2\Backup\"
$filedate = (Get-Date).AddDays(-1).ToString("yyyyMMdd")
$filter = "FULL_(local)_Product_$filedate"
Get-ChildItem -Path $source | Where-Object { $_.Name -match $filter } | Copy-Item -Destination $destination

If you're still not getting any results, then we need to look at the filter itself.

Related resources:

PowerShell Conditional Operators

edited Jul 5, 2011 at 10:07

answered Jul 5, 2011 at 10:00

Enrico Campidoglio

60.8k13 gold badges137 silver badges159 bronze badges

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

1 Comment

Joe Johnston Over a year ago

| Copy-Item -Destination $destination

Collectives™ on Stack Overflow

Match file name and copy using PowerShell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related