MobileRead Forums - View Single Post

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?

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?