Regular expression to clean title

dunhill · 08-05-2020, 08:26 PM

Hello people, I have books in which the title appears like this:
The Heart of Darkness [trans. Miguel Early Garcia]
I would like to put a regular expression when adding books, that I clean everything that is between the [] or ()
Could you help me?
From already very grateful

dunhill · 08-06-2020, 07:51 PM

Apparently not possible

theducks · 08-06-2020, 08:31 PM

Quote:

Originally Posted by dunhill

Apparently not possible

You hung the requirement 'while adding'.
I do not even attempt things like that when it is so easy to bulk fix a Particular type of condition, using the MDE. If it reoccurs, I save the S&R (a feature of the MDE (bulk mod S&R)

dunhill · 08-06-2020, 08:53 PM

Quote:

Originally Posted by theducks

You hung the requirement 'while adding'.
I do not even attempt things like that when it is so easy to bulk fix a Particular type of condition, using the MDE. If it reoccurs, I save the S&R (a feature of the MDE (bulk mod S&R)

I usually edit all the metadata so I can complete my custom columns.

But I have come across some books that have braces or parentheses in the title.
Thanks for answering theducks !!!

davidfor · 08-06-2020, 11:03 PM

@dunhill: I did have a quick look at it when you posted. I could see some problems and hoped someone else would come along

The following will handle the case you mentioned:

Code:

(?P<title>[^\[\(]+)\s*(\[.*\]|\(.*\))?

But, it doesn't take into account the other metadata attributes. How to add the other attributes is the problem. Does the second part get added after the title in the regex? Or somewhere else?

I think I like @theducks suggestion. The above regex should work with the bulk search&replace.

theducks · 08-06-2020, 11:09 PM

Quote:

Originally Posted by dunhill

I usually edit all the metadata so I can complete my custom columns.

But I have come across some books that have braces or parentheses in the title.
Thanks for answering theducks !!!

(.+) \[trans\.\s (.+?)\]
\1 is the title
\2 is the name (without trans. )
so you could APPEND to {authors}: \2 (trans)
As you can see, this is fragile: in that it expects trans.(space)

dunhill · 08-06-2020, 11:44 PM

Thank you very much.
Ok I'm going to try the alternatives, S / R seems more dynamic to me
Theducks and Davifor

08-05-2020, 08:26 PM	#1
dunhill Guru Posts: 889 Karma: 409970 Join Date: Sep 2017 Location: Buenos Aires, Argentina Device: moon+ reader, kindle paperwhite	Regular expression to clean title Hello people, I have books in which the title appears like this: The Heart of Darkness [trans. Miguel Early Garcia] I would like to put a regular expression when adding books, that I clean everything that is between the [] or () Could you help me? From already very grateful Last edited by dunhill; 08-06-2020 at 07:53 PM.

08-06-2020, 11:03 PM	#5
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	@dunhill: I did have a quick look at it when you posted. I could see some problems and hoped someone else would come along The following will handle the case you mentioned: Code: (?P<title>[^\[\(]+)\s(\[.\]\|\(.*\))? But, it doesn't take into account the other metadata attributes. How to add the other attributes is the problem. Does the second part get added after the title in the regex? Or somewhere else? I think I like @theducks suggestion. The above regex should work with the bulk search&replace.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is this possible using a regular expression?	unabatedshagie	Library Management	2	03-17-2016 09:47 AM
Please help me with regular expression :help:	Tatjana	Library Management	2	05-30-2014 05:41 PM
Search for a regular expression in title and move it to series	venunayar	Calibre	0	03-27-2013 12:43 PM
Regular expression for Title sort	kakkalla	Calibre	8	01-19-2011 06:45 PM
Regular expression help	krendk	Calibre	4	12-04-2010 04:32 PM

08-06-2020, 07:51 PM	#2
dunhill Guru Posts: 889 Karma: 409970 Join Date: Sep 2017 Location: Buenos Aires, Argentina Device: moon+ reader, kindle paperwhite	Apparently not possible

08-06-2020, 11:44 PM	#7
dunhill Guru Posts: 889 Karma: 409970 Join Date: Sep 2017 Location: Buenos Aires, Argentina Device: moon+ reader, kindle paperwhite	Thank you very much. Ok I'm going to try the alternatives, S / R seems more dynamic to me Theducks and Davifor

Advert

Advert