Title search problem (spin off of another post)

[BunnyGal]

I recently posted a problem of not getting the results I expected doing a title search. fortunately the knowlegeable and helpful people on this board were able to show me what I was doing wrong.

However, now i've run into another problem. I discussed this in a follup-up to my other post, but i'm hoping that starting a new thread might catch more eyes for a quicker answer

My search query is title:"raw"
My goal is to have the books with the word raw in the title.

It does give me the books i want, but others i dont want.

It gives me raw, draw, rawhide, overdrawn, ect.

How to I get the search to include the word "raw" but not words that contain the letters r a w. I thought the quotes would do the trick, but it hasn't.

Here is a link to a screenshot of my query and results. Sorry for the low resolution. Items 23 and 24 in the list show examples of unwanted items.

http://www.flickr.com/photos/67955435@N06/11863157136/

Thank you!

Lisa

[BetterRed]

Originally Posted by BunnyGal

I recently posted a problem of not getting the results I expected doing a title search. fortunately the knowlegeable and helpful people on this board were able to show me what I was doing wrong.

However, now i've run into another problem. I discussed this in a follup-up to my other post, but i'm hoping that starting a new thread might catch more eyes for a quicker answer

My search query is title:"raw"
My goal is to have the books with the word raw in the title.

It does give me the books i want, but others i dont want.

It gives me raw, draw, rawhide, overdrawn, ect.

How to I get the search to include the word "raw" but not words that contain the letters r a w. I thought the quotes would do the trick, but it hasn't.

Here is a link to a screenshot of my query and results. Sorry for the low resolution. Items 23 and 24 in the list show examples of unwanted items.

http://www.flickr.com/photos/67955435@N06/11863157136/

Thank you!

Lisa

can't see your picture (wants me to logon to yahoo) - doesn't matter

doesn't title:"=raw" work ? IMO it should

To add an attachment here, Click Manage Attachments (its below the compose message window) then see picture

One. Browse to your attachment(s)
Two. Click Upload and wait until it displays the filenames
Three. Click Close Window

BR

[BunnyGal]

Originally Posted by BetterRed

can't see your picture (wants me to logon to yahoo) - doesn't matter

doesn't title:"=raw" work ? IMO it should

To add an attachment here, Click Manage Attachments (its below the compose message window) then see picture

One. Browse to your attachment(s)
Two. Click Upload and wait until it displays the filenames
Three. Click Close Window

BR

Thanks! I wasn't trying to add an attachment, but rather insert the picture directly into my post. I've included it as an attachement.

The search query title:"=raw" wants books where the title is nothing other than the word raw, rather than a title with the word raw in it. I get a message that no results are found, because I dont own a book titled "raw". I have raw veggies, raw fruit dishes, etc. but not just raw.

There must be an advanced search query that returns the books that have the word raw in the title, but not the letters r a w in another word in the title.

I read the entire manual and it didn't solve my issue.

The pic. of my issue should be attached.

[BunnyGal]

I just again tried title:"=raw" and the results are:

"The search found no books mathing this title so the search result will be empty.
Do you really want to use this search?"

[BetterRed]

Of course

what you want is a contains whole word search, looks like there isn't a direct method which means regular expression

I don't use calibres re, but elsewhere I would use \braw\b - the \b is a word boundary marker, which should take care of punctuation and space.

BR

[BunnyGal]

Originally Posted by BetterRed

, but elsewhere I would use \braw\b - the \b is a word boundary marker, which should take care of punctuation and space.

BR

very confused....... I'm not nearly as experienced as you and have NO CLUE LOL what you are suggesting!

Can you give me an example - by writing out how you would change

This search Title:raw or Title:"raw" to incorporate what you are trying to say?

Perhaps something I can cut and paste

Thank you.

[eschwartz]

Huh, I just answered this at your original thread:

Originally Posted by eschwartz

Perhaps someone knows something better, but you could try the following regular expressions search:

title:"~\braw\b"

The ~ turns it into a regex search, the \b matches a word boundary (either beginning or end of word).

[BunnyGal]

Originally Posted by eschwartz

Huh, I just answered this at your original thread:

THAT WORKED!!!

You ARE amazing. This has been bugging me for months.

Okay..... I know that your copied and pasted search was/is correct, but how can i apply it to other searches - for a different title or author, etc.

What is the "formula" (probably not the right word) that I use, or simply - how do I do it?

[eschwartz]

you can learn all about regular expressions at http://www.regular-expressions.info

you search a particular field -- say, authors or title -- by starting with the name of the field, followed by ":" as in our previous case, search title for "raw", we used "title:" next comes the search term, enclosed in quotes. title:"raw" will search for "raw", title:"~raw" wil search for the REGEX of "raw". Using the regex symbol "\b" we match word boundaries. So to find an author that includes the name "John" we search for

authors:"~\bJohn\b"

which will NOT match Johnathan, though

authors:"John"

would match Johnathan.

meta-field:"meta-value" -- search for anything that includes "meta-value" matching within (limited to) type (column) "meta-field".

meta-field:"=meta-value" -- search for the exact value "meta-value" limited to type (column) "meta-field"

meta-field:"~meta-value" -- search for the regex "meta-value" that matches within (limited to) type (column) "meta-field"

AND/OR/NOT/AND NOT/OR NOT can be used to search for multiple things at the same time, they are your standard boolean search operators.

[theducks]

Originally Posted by BunnyGal

THAT WORKED!!!

You ARE amazing. This has been bugging me for months.

Okay..... I know that your copied and pasted search was/is correct, but how can i apply it to other searches - for a different title or author, etc.

What is the "formula" (probably not the right word) that I use, or simply - how do I do it?

The squiggle means REGEX mode
The \b is a blank (I might make the first one \b* to mean 0 or 1 Blanks in case it is the first word) (\b|^) might be better as it means Blank or start of line
raw well that is a guess
The last \b is a trailing blank (a space or Eol must follow)

[BetterRed]

Originally Posted by BunnyGal

Okay..... I know that your copied and pasted search was/is correct, but how can i apply it to other searches - for a different title or author, etc.

What is the "formula" (probably not the right word) that I use, or simply - how do I do it?

You might find it easier to use the Advanced Search (binoculars to left of search bar) - saves having to remember the column names, and you don't need to find the tilde key (~)

Basically you put \b (boundary marker) at the start and end of the whole word(s) you want match

You get to see the resultant search term in the search bar when you hit OK - its a good way to learn

The example in the attachment is of course silly, but maybe not if you changed it to

(title:"~\bsyllabub\b") or (author:"~\bBeeton\b") or (comments:"~\bdinner party\b and "fish"")

BR

[BunnyGal]

Originally Posted by BetterRed

You might find it easier to use the Advanced Search (binoculars to left of search bar) - saves having to remember the column names, and you don't need to find the tilde key (~)

__________________

Thank you. I truly appreciate all the help you've given me. I haven't had the time to learn the details about regex searches, but I will. For now, the /b "boundary marker" feature you showed me works wonderfully and has saved me a lot of time.

Best wishes for the new year!

Lisa