Regex Search in Advanced Search Box

franknight · 07-08-2020, 10:48 AM

He all:
I get along pretty well with Regex in calibre using it modify titles. But I'm having trouble with a regular expression search in the Advanced Search: Regular Expression: Author field. I want to search my library for authors that have initials without a '.' after the initial. The format of all such authors in my library (which is quite large) is 'capital letter' followed by '.' followed by a 'space' I want to find the ones where I forgot the '.' So 'John A. Trouble' is OK. But I want to find 'John A Trouble' Closest I've come with my meager knowledge of Regex is "X +" which finds all authors with an 'x' at the end of either their first or last name. Doesn't even restrict the finds to a capital 'X' Thanks for looking at my dilemma. frank

chaley · 07-08-2020, 12:22 PM

If I am understanding you correctly, you want to find any author containing a space then a single letter then a space. If so, then this works

Code:

author:"~ \w "

If the single letter can be the first letter of the author's name then this works:

Code:

author:"~(^| )\w "

davidfor · 07-09-2020, 12:42 AM

@franknight: Try the Quality Check plugin. It has a search for authors with initials and can fix the missing dot.

07-08-2020, 10:48 AM	#1
franknight Member Posts: 16 Karma: 10 Join Date: Sep 2018 Device: kindle	Regex Search in Advanced Search Box He all: I get along pretty well with Regex in calibre using it modify titles. But I'm having trouble with a regular expression search in the Advanced Search: Regular Expression: Author field. I want to search my library for authors that have initials without a '.' after the initial. The format of all such authors in my library (which is quite large) is 'capital letter' followed by '.' followed by a 'space' I want to find the ones where I forgot the '.' So 'John A. Trouble' is OK. But I want to find 'John A Trouble' Closest I've come with my meager knowledge of Regex is "X +" which finds all authors with an 'x' at the end of either their first or last name. Doesn't even restrict the finds to a capital 'X' Thanks for looking at my dilemma. frank

07-08-2020, 12:22 PM	#2
chaley Grand Sorcerer Posts: 12,528 Karma: 8065948 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	If I am understanding you correctly, you want to find any author containing a space then a single letter then a space. If so, then this works Code: author:"~ \w " If the single letter can be the first letter of the author's name then this works: Code: author:"~(^\| )\w "

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

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 08:10 PM
Advanced search within ebook using application or regex	Earthlark	Calibre	3	02-04-2014 04:33 AM
Advanced search within ebook using application or regex	Earthlark	General Discussions	2	02-04-2014 01:10 AM
Problem using 'Advanced Search' with 'Search in Forum'	Wetdogeared	Feedback	6	06-21-2011 10:37 AM
Strange behavior with advanced catalog search (regex)	QuantumBeep	Library Management	1	02-21-2011 12:06 PM

07-09-2020, 12:42 AM	#3
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	@franknight: Try the Quality Check plugin. It has a search for authors with initials and can fix the missing dot.

Advert