Thread: How to search Author column for "The " or "A "
View Single Post
Old 07-21-2014, 02:11 PM   #2
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: 31,166
Karma: 60406498
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Inferno View Post
I am trying to search my Author(s) column for "The " or "A ". When I search for "The " I get a great number of results including Theo etc.

What I am trying to do is find those books that have the author and title reversed. I can't see how to use regex to search the author column.

I don't want to search and replace. Just to find these books so I can "eyeball" them.
Try the Quality Check Plugin
It has all sorts of metadata checks (but not the A or The)

Code:
title:="~^The"
should find those that Start with 'The'
theducks is offline   Reply With Quote