Bulk Metadata Edit search replace Question

Paltieldav · 02-29-2016, 04:49 PM

Hey All,

I have a number of books that have (XXXX) before the title. x being a number.

I want to get rid of the parentheses and numbers all in one shot. The numbers vary from title to title.

Whats the best way of doing that?

Thanks

eschwartz · 02-29-2016, 05:45 PM

Using a regular expression.

(You need to switch from "character match" mode to "regular expression" mode. See HERE.)

Find:

Code:

\(\d+\)(.*)

Replace:

Code:

\1

Quadrivium · 02-29-2016, 05:47 PM

Use Edit metadata in bulk
Select [I]Search and replace[/u] tab
Load search/replace: blank
Search field: title
Search for: a regex
Replace with: blank
Destination field: title

Use a regular expression (regex) to find the thing you want to replace
Given a titles of the form
(123) …
(6789)
The regex is
‘\(\d+\) ‘ [without the ‘s]
The regex: find left paren followed by 1 or more digits followed by right paren folloed by space.

theducks · 02-29-2016, 06:47 PM

Quote:

Originally Posted by Paltieldav

Hey All,

I have a number of books that have (XXXX) before the title. x being a number.

I want to get rid of the parentheses and numbers all in one shot. The numbers vary from title to title.

Whats the best way of doing that?

Thanks

Pick answer in #2
REGEX (mode) is king

Paltieldav · 02-29-2016, 07:58 PM

Quote:

Originally Posted by eschwartz

Using a regular expression.

(You need to switch from "character match" mode to "regular expression" mode. See HERE.)

Find:

Code:

\(\d+\)(.*)

Replace:

Code:

\1

Thank you!

Paltieldav · 03-01-2016, 06:12 AM

Quote:

Originally Posted by Quadrivium

Use Edit metadata in bulk
Select [I]Search and replace[/u] tab
Load search/replace: blank
Search field: title
Search for: a regex
Replace with: blank
Destination field: title

Use a regular expression (regex) to find the thing you want to replace
Given a titles of the form
(123) …
(6789)
The regex is
‘\(\d+\) ‘ [without the ‘s]
The regex: find left paren followed by 1 or more digits followed by right paren folloed by space.

Thank you!

02-29-2016, 04:49 PM	#1
Paltieldav Enthusiast Posts: 25 Karma: 10 Join Date: Feb 2016 Device: Amazon Kindle Fire	Bulk Metadata Edit search replace Question Hey All, I have a number of books that have (XXXX) before the title. x being a number. I want to get rid of the parentheses and numbers all in one shot. The numbers vary from title to title. Whats the best way of doing that? Thanks

02-29-2016, 05:47 PM	#3
Quadrivium Junior Member Posts: 3 Karma: 10 Join Date: Feb 2014 Device: Kindle Fire	Delete (123...) from title Use Edit metadata in bulk Select [I]Search and replace[/u] tab Load search/replace: blank Search field: title Search for: a regex Replace with: blank Destination field: title Use a regular expression (regex) to find the thing you want to replace Given a titles of the form (123) … (6789) The regex is ‘\(\d+\) ‘ [without the ‘s] The regex: find left paren followed by 1 or more digits followed by right paren folloed by space.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Regex search and replace in bulk metadata help	slantybard	Library Management	7	08-20-2015 06:30 PM
Edit metadata in bulk vs search and replace	inl1ner	Library Management	6	07-14-2014 06:58 PM
Calibre Bulk edit Mode says Search/Replace invalid when it is not even used	tempura	Library Management	10	04-03-2014 05:23 PM
Bulk search and replace operations - question	SFD1968	Calibre	1	03-01-2013 09:23 AM
2 Questions about Bulk Edit Search & Replace	BookJunkieLI	Library Management	6	02-19-2012 01:39 PM

02-29-2016, 05:45 PM	#2
eschwartz Ex-Helpdesk Junkie Posts: 19,422 Karma: 85397180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Using a regular expression. (You need to switch from "character match" mode to "regular expression" mode. See HERE.) Find: Code: \(\d+\)(.) Replace: Code: \1 Last edited by eschwartz; 02-29-2016 at 05:48 PM.*

Advert

Advert