Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 08-11-2018, 01:19 PM   #1
please55
Connoisseur
please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.
 
Posts: 60
Karma: 72010
Join Date: Nov 2014
Device: none
Search string to filter out two values

Hello having a bit of trouble with a search/filter.

I'm trying to filter out any books that contain the word 'vintage' or 'faber' in the publisher field.

So far I've managed -
not publisher:vintage

But the following don't seem to work -
not publisher:vintage or publisher:faber
not publisher:vintage or not publisher:faber
not publisher:vintage or faber
not publisher:vintage faber

Can I do what I want? Thanks
please55 is offline   Reply With Quote
Old 08-11-2018, 02:29 PM   #2
Adoby
Handy Elephant
Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.
 
Adoby's Avatar
 
Posts: 1,575
Karma: 15514758
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Thinkpad E595, Ubuntu Mate, Huawei Mediapad 5, Bouye Likebook Plus
There are two functionally identical alternatives:

not publisher:vintage and not publisher:faber

not (publisher:vintage or publisher:faber)
Adoby is offline   Reply With Quote
Advert
Old 08-11-2018, 02:39 PM   #3
please55
Connoisseur
please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.
 
Posts: 60
Karma: 72010
Join Date: Nov 2014
Device: none
Thank you. Have to admit I don't get the logical process that:
not publisher:vintage or not publisher:faber
isn't actually what I'm trying to specify.
please55 is offline   Reply With Quote
Old 08-11-2018, 02:48 PM   #4
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 24,198
Karma: 27941849
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT, Galaxy Tab A, Kobo Aura2
Open the Tag browser: Publisher

click Publisher #1 twice (red minus will show)
Hold down the control key
repeat for each additional Publisher

BTW at the bottom of the tag browser there is a crossed tools Icon: choose Match all
theducks is offline   Reply With Quote
Old 08-11-2018, 04:25 PM   #5
itimpi
Wizard
itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.
 
Posts: 4,504
Karma: 950063
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
Quote:
Originally Posted by please55 View Post
Thank you. Have to admit I don't get the logical process that:
not publisher:vintage or not publisher:faber
isn't actually what I'm trying to specify.
This will always equate to true as with the ‘or’ used in this way it could only return false was if the publisher was simultaneously ‘vintage’ AND ‘Fabre’. Under any other condition at least one side of the ‘or’ would be true so the expressions as a whole would equate to true.
itimpi is online now   Reply With Quote
Advert
Old 08-11-2018, 04:43 PM   #6
chaley
Grumpy old git
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 9,030
Karma: 2737842
Join Date: Jan 2010
Location: UK
Device: Many android devices
Quote:
Originally Posted by please55 View Post
Thank you. Have to admit I don't get the logical process that:
not publisher:vintage or not publisher:faber
isn't actually what I'm trying to specify.
Entering Boolean Algebra zone ...

It doesn't work because the expression you wrote will match any publisher that isn't both vintage and faber, which clearly can never happen. Why does it match?

The OR operator returns TRUE if either the left or the right expression returns TRUE. The only way OR can return FALSE is if both the left and right return FALSE. Consider a book with publisher "vintage". The first expression (not publisher:vintage) returns FALSE, but the second expression (not publisher:faber) returns TRUE. FALSE or TRUE equals TRUE. The same is true for a book with publisher "faber". The first expression returns TRUE because faber is not vintage. The second expression returns FALSE because faber is faber. TRUE or FALSE returns TRUE.

You are looking for books that are neither vintage nor faber. In other words you are looking for books where either (not both) the left or the right expression returns FALSE. This requires the AND operator, which returns TRUE if both the left and right expressions return TRUE, otherwise it returns FALSE.

FWIW 1: this site shows the "truth tables" for boolean operators such as AND and OR. A "truth table" provides the result for all possible inputs.

FWIW 2: Adoby's response makes use of something called De Morgan's laws. These "laws" provide conversions between AND and OR expressions so that the expressions provide the same answer.
chaley is offline   Reply With Quote
Old 08-13-2018, 12:37 AM   #7
please55
Connoisseur
please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.
 
Posts: 60
Karma: 72010
Join Date: Nov 2014
Device: none
Quote:
Originally Posted by chaley View Post
Entering Boolean Algebra zone ...

It doesn't work because the expression you wrote will match any publisher that isn't both vintage and faber, which clearly can never happen. Why does it match?

The OR operator returns TRUE if either the left or the right expression returns TRUE. The only way OR can return FALSE is if both the left and right return FALSE. Consider a book with publisher "vintage". The first expression (not publisher:vintage) returns FALSE, but the second expression (not publisher:faber) returns TRUE. FALSE or TRUE equals TRUE. The same is true for a book with publisher "faber". The first expression returns TRUE because faber is not vintage. The second expression returns FALSE because faber is faber. TRUE or FALSE returns TRUE.

You are looking for books that are neither vintage nor faber. In other words you are looking for books where either (not both) the left or the right expression returns FALSE. This requires the AND operator, which returns TRUE if both the left and right expressions return TRUE, otherwise it returns FALSE.

FWIW 1: this site shows the "truth tables" for boolean operators such as AND and OR. A "truth table" provides the result for all possible inputs.

FWIW 2: Adoby's response makes use of something called De Morgan's laws. These "laws" provide conversions between AND and OR expressions so that the expressions provide the same answer.
Thank you everyone. This always tricked me up when I did intro CS courses.

@ducks picked up this method after rereading manual shortly before coming back here. Somehow escaped my mind to use windows ctrl function for multiple selection.

Last edited by please55; 08-13-2018 at 12:45 AM.
please55 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I use a search string with CC? peaceridge Calibre Companion 7 02-23-2015 05:25 PM
how to search between 2 values kindleboy Library Management 2 11-05-2013 11:01 AM
How do I stop a string search on my Kindle 3 niceboy Amazon Kindle 2 06-30-2011 08:38 PM
Error when inputting a search string in V0.6.37 solitaire Calibre 1 02-06-2010 12:29 AM
Search for files by content string? nekokami iRex 4 12-01-2006 01:14 PM


All times are GMT -4. The time now is 07:12 PM.


MobileRead.com is a privately owned, operated and funded community.