Windows 10: Search syntax for "folders containing specific file types" ??

Does anyone know if there is a syntax for finding all folders containing certain types of files? Like if I wanted to find every folder on my D drive containing photos (and have just the folders listed in the search results.) Or find every folder containing ebooks, whatever. How would I do this?

Thanks!

:)

 

How to Search in Windows 10 for files containing a specific formula?

I have a file folder containing about 100 Excel workbooks that I've sent to a large number of users. It's a standard workbook but each one has been tailored to the specific user with entity name, staff names, etc. I discovered that some of the files contain
a formula error. How can I search the folder for the files containing the incorrect formula? I don't want to send the macro to every user, just the ones with the 'bad' formula. When I use the search box in Windows 10 it returns zero files, although I did
select "Files Containing". Is there a syntax I'm supposed to be using in the search box to indicate that I'm searching for a formula? The formula is: =SUM(Deviations!D910)

Thank you!

 

File Explorer search syntax

There is no complete, official reference that I've ever found. The closest is this:

Advabced Quert Syntax

But even that is incomplete.

Here are key concepts I've learned:

• If serching for names with special characters normally used in search syntax, the text must me enclosed in quotes:

Code:

[b]name:"(8).txt"[/b]

• But if you try the above with wildcards, you'll be disappointed. For wildcards to be used within quoted strings, you have to use a tilde ':~':

Code:

[b]name:~"*(*)*" <- any item with parentheses in name.[/b]

• To search for empty properties, use empty square brackets:

Code:

[b]ext:.jpg DateTaken:[][/b]

• You can narrow Search Results to a specific folder or sub-folder by including
  FolderName in your search:

Code:

[b]ext:.jpg DateTaken:[] FolderName:Charlie[/b]

I think I've covered the most common needs. Happy to follow-up if you have more spedific questions.

Keith

 

Conditional searches for folder that contain a specfic combantion of file extenisions

Cab anyone help with the following problem

I have about 1,000 book folders that contain either1, 2 or 3 files with the extensions OPF , JPG and EPUB.

What I would like to do is a search on the folders that would list all those folders that contain OPF and JPG file extensions only. if it contains a file with the .EPUB extension I want the search to ignore the folder.

I've tried using the Search box in File Explorer with Boolean Logic (AND NOT OR) with no joy and I've tried regular expression but having trouble getting my head around how to set the expression.

If anyone could help by suggesting a solution or even a file search program it would be appreciated.

If posted in wrong area please tell me and I will move it