Need a way to script powershell select-string pattern from multiple subfolders

[Dave2008]

In Powershell I run the following script that works fine for one folder only.
Can I run the script on one folder with multiple subfolders?
Right now I have to copy all files from each subfolder to one main folder

PS C:\main folder> Select-string "897-2" .\*xls | select -u -exp filename

shows me all the names of all the files

Using Windows 7 Pro

 

[markdmac]

Get-ChildItem -File -Recurse | Select-string "897-2" .\*xls | select -u -exp filename

I hope that helps.

Regards,

Mark

No trees were harmed in posting this message, however a significant number of electrons were terribly inconvenienced.

Work SMARTER not HARDER.

 

[Dave2008]

Sorry it didn't work
I'm new to this. Police Documents folder has about 5 subfolders with a lot of excel files. We're a manufacturer and looking to find a pattern that would be used in different files. Thank you

PS C:\0lf\police documents> Get-ChildItem -File -Recurse | Select-string "897-2" .\*.xls | select -u -ex
Get-ChildItem : A parameter cannot be found that matches parameter name 'File'.
At line:1 char:20
+ Get-ChildItem -File <<<< -Recurse | Select-string "897-2" .\*.xls | select -u -exp filename.
+ CategoryInfo : InvalidArgument: ) [Get-ChildItem], ParameterBindingException
+ FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.PowerShell.Commands.GetChildItemCommand