How to exclude custom column multiple search strings ?

[anmac1789]

Hello, how do I use multiple exclude name with ! in custom column ?

For example, I have !column1:="PHOTO-2019" which excludes all column names containing the string "PHOTO-2019" but I want to add another search term with ? for files of the format 20221229_123040.jpg --> 20??????_??????.jpg

I have used !column1:"PHOTO-2019","20??????_??????.jpg " using the comma ( , ) and semi-colon ( ; ) but both of these don't work. How can I add multiple search terms with !column1: ?

[void]

Please try the following search:

!wildcard:column1:<"PHOTO-2019" "20??????_??????.jpg">

< and > = subexpression.
wildcard: = enable content wildcards (required as column1: is not a "filename" search function)



Alternative search:

!column1:"PHOTO-2019" !wildcard:column1:"20??????_??????.jpg"

[anmac1789]

Please try the following search:

!wildcard:column1:<"PHOTO-2019" "20??????_??????.jpg">

< and > = subexpression.
wildcard: = enable content wildcards (required as column1: is not a "filename" search function)

This didn't do anything it still showes the results its supposed to not show

[void]

Check if the following matches column1 as expected:

wildcard:column1:"20??????_??????.jpg"

adjust the search as needed.



Is column1 a multistring value?

[anmac1789]

Check if the following matches column1 as expected:

wildcard:column1:"20??????_??????.jpg"

What is this supposed to do anyway ?

Is column1 a multistring value?

yes column 1 has column1:”PHOTO-2019”

[void]

What is this supposed to do anyway ?

Match: 20241230_160434.jpg

Are you not seeing the expected match?
Can you give an example filename?

Wildcards match the whole property.
Please try:
wildcard:column1:*20??????_??????.jpg*

yes column 1 has column1:”PHOTO-2019”

Is column1 showing multiple values. (comma separated)
For example:
PHOTO-2019,PHOTO-2019#2,PHOTO-2019#3,...

[anmac1789]

What is this supposed to do anyway ?

Match: 20241230_160434.jpg

Are you not seeing the expected match?
Can you give an example filename?

Wildcards match the whole property.
Please try:
wildcard:column1:*20??????_??????.jpg*

yes column 1 has column1:”PHOTO-2019”

I mean is column1 showing multiple values. (comma separated)
For example:
PHOTO-2019,PHOTO-2019#2,PHOTO-2019#3,...

What I have is

column1:=name: wildcard:column1:"*PHOTO-2019*"

but I also wish to include "20??????_??????.jpg" with the !column1:

[void]

Can you please give an example filename?



Did the following search help:

wildcard:column1:*20??????_??????.jpg

Apply the NOT operator: ! if you see the expected results.



It would be much faster and efficient to perform the search on the name directly.

The name: function is a filename function, so wildcard will work naturally.

Please try the following search:

name:PHOTO-2019 !name:*20??????_??????.jpg