Search/Replace where Field1 = Field2

Hylas01 · 02-13-2018, 02:38 PM

Hi.
I've got about 7 thousand books where the import went a bit off and I have the author's name equal to the title's name: e.g: Title = "My Favorite Book" and Author = "My Favorite Book."

I'd like to search for all of these occurrences and then replace Author with "unknown."

The regular expression searches are a bit beyond me. Is there a way to search for a field that's equal to another field? It seems like it should be something like %title% = %author% but I'm not having much luck... Help?

ilovejedd · 02-13-2018, 02:49 PM

Try the Multi-Column Search plugin.

Hylas01 · 02-13-2018, 04:49 PM

Quote:

Originally Posted by ilovejedd

Try the Multi-Column Search plugin.

Perfect! Thank you!

02-13-2018, 02:38 PM	#1
Hylas01 Junior Member Posts: 2 Karma: 10 Join Date: Feb 2018 Device: Kindle	Search/Replace where Field1 = Field2 Hi. I've got about 7 thousand books where the import went a bit off and I have the author's name equal to the title's name: e.g: Title = "My Favorite Book" and Author = "My Favorite Book." I'd like to search for all of these occurrences and then replace Author with "unknown." The regular expression searches are a bit beyond me. Is there a way to search for a field that's equal to another field? It seems like it should be something like %title% = %author% but I'm not having much luck... Help?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Regex in search problems (NOT Search&Replace; the search bar)	lairdb	Calibre	3	03-15-2017 07:10 PM
Help with Search and Replace Please	madelonw	Library Management	5	06-13-2014 03:55 PM
save multiple search/replace, or search/replace multiple ebooks	user743	Editor	12	04-12-2014 02:38 AM
Search and Replace	SOThunder	Conversion	2	04-29-2012 08:29 AM
search and replace - drops blanks in replace ?	cybmole	Conversion	10	03-13-2011 03:07 AM

02-13-2018, 02:49 PM	#2
ilovejedd hopeless n00b Posts: 5,111 Karma: 19597086 Join Date: Jan 2009 Location: in the middle of nowhere Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9	Try the Multi-Column Search plugin.

Advert