Full Text Search and Parenthesis?

chicleeblair · 09-23-2023, 02: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, 02: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, 07: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, 02: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 09:20 PM
Full-text search not really full-text	secasa	Library Management	5	10-01-2022 11:11 PM
regex parenthesis text formatting question!	ksimpson1986	Sigil	3	11-10-2016 02:54 AM
Full Text Search?	silentguy	Calibre	4	02-22-2012 04: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 01:13 PM

09-23-2023, 02:51 AM	#2
kovidgoyal creator of calibre Posts: 45,706 Karma: 28549304 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, 07:27 PM	#3
Comfy.n want to learn what I want Posts: 1,709 Karma: 7908443 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