Options

Help Request - Tell me where my Syntax is wrong! (Powershell)

Here’s the gist of what I’m trying to do – I don’t know if this is the best way of doing it or not, but I’m fairly confident that this is something that can be done in Powershell.


I have a list of filenames that I believe are located on the file server, and these files are currently setting in a text file. Unfortunately, most of the files that I still need to locate are not an exact match. There’s a backstory to it why, but I suspect that the filenames in the list are at least contained in the actual filename. I know that sounds confusing, but for example:




In the list: F-6.3-005_1
On the server: F-6.3-005_1Crane Inspection Report Form.pdf


So I do have a match, but just not on the entire file name. I know that Powershell allows the –like parameter when using the Where-Object cmdlet, and it allows wildcards, so I adjusted the filename list to have an asterisk before and after the filename. So in reality, the list actually reads the file as *F-6.3-005_1*.


I want to perform a search of all files on the server, using the filenames as what I’m searching for, and I want to results of the search to come back in a log (CSV or whatever).


What I’ve done is as follows:


$files = Get-Content C:\filenames.txt


Get-ChildItem (Directory) | Where-Object {$_.Name –like $files} | Export-CSV C:\output.csv


I think my syntax is wrong where I call the variable $files in the Where-Object, and I’m not sure how to correct it. I played around with the idea of forcing it through a ForEach statement, but again, I think my syntax is wrong. (and that may not even be necessary, as I’ve read that Powershell will already run through the content as an array)

Comments

Sign In or Register to comment.