Full Text Search and Parenthesis?

chicleeblair · 09-23-2023, 01:27 AM

I know this is simple, and I've learned regex for the other searches, but I can't seem to figure out how to include special characters, specifically ( or ) in full-text search. I think it'll accept ASCII, but I don't exactly know how to read the table, let alone how to input it so that the search will accept it.

So, a general answer would be great, because I'm sure I'll need things like : and - at some point, but if you could also just tell me how to make it find (new) in the text, that'd be swell.

kovidgoyal · 09-23-2023, 01:51 AM

full text search is word based, so it cant search for special characters as they are not words. You might be able to do something like

NEAR("(" "new" ")" 3)

Comfy.n · 10-04-2023, 06:27 PM

For EPUB files, I believe you can use the Quality Check Plugin Search ePubs tool, as it can run regex based searches.

09-23-2023, 01:27 AM	#1
chicleeblair Connoisseur Posts: 97 Karma: 10 Join Date: Sep 2018 Device: iPad mini	Full Text Search and Parenthesis? I know this is simple, and I've learned regex for the other searches, but I can't seem to figure out how to include special characters, specifically ( or ) in full-text search. I think it'll accept ASCII, but I don't exactly know how to read the table, let alone how to input it so that the search will accept it. So, a general answer would be great, because I'm sure I'll need things like : and - at some point, but if you could also just tell me how to make it find (new) in the text, that'd be swell.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Full text search	Steve0412	Library Management	3	11-12-2022 08:20 PM
Full-text search not really full-text	secasa	Library Management	5	10-01-2022 10:11 PM
regex parenthesis text formatting question!	ksimpson1986	Sigil	3	11-10-2016 01:54 AM
Full Text Search?	silentguy	Calibre	4	02-22-2012 03:03 PM
Google Book Search to search full-text books online	Bob Russell	Deals and Resources (No Self-Promotion or Affiliate Links)	1	08-19-2006 12:13 PM

09-23-2023, 01:51 AM	#2
kovidgoyal creator of calibre Posts: 45,311 Karma: 27111242 Join Date: Oct 2006 Location: Mumbai, India Device: Various	full text search is word based, so it cant search for special characters as they are not words. You might be able to do something like NEAR("(" "new" ")" 3)

10-04-2023, 06:27 PM	#3
Comfy.n want to learn what I want Posts: 1,609 Karma: 7891011 Join Date: Sep 2020 Device: none	For EPUB files, I believe you can use the Quality Check Plugin Search ePubs tool, as it can run regex based searches.

Advert