How to exclude specific files using DOS Expression?

Question

I want to search in all *.sql files but exclude one large but irrelevant file. I have specified in the 'File name' textbox:

*.sql; NOT:DnB.CLR.CCBLogging.publish.sql

with selected option "DOS Expression" in the drop-down list on the right.

The search finds nothing. But if I remove that NOT:..... section, it finds correct hits in many *.sql files (no hits in 'DnB.CLR.CCBLogging.publish.sql' file anyway, it is just too big and irrelevant to waste time searching)

How to combine normal wild cards with NOT: in DOS Expression?

Answer 1

Try removing the space after the semi-colon:

 *.sql;NOT:DnB.CLR.CCBLogging.publish.sql

It shouldn't be quite so sensitive but this should sort it out for now.

Comments

Yes, removing that space does the trick! Now this search works as expected.
Thank you, Dave