MobileRead Forums - View Single Post - Searching and replacing in different fields

lbutlr · 07-23-2022, 01:03 PM

I imported some books that had titles like “Name of Series 01 Title of First book in series”. I tried to use the multi-edit find and replace to set the series name and index number and was able to do so. I ended up doing it by hand, but I am curious if this is possible.

First, I searched title for (\d\d) and tried to set the index number to \1 but got a string conversion error. I am guessing that Calibre did not like the ’01’ and that I would need to somehow get a ‘1’ and also get a ’11’, but I didn’t have time to figure out the regex for that… ([1-9]?\d) maybe?)

Also, it looks like this would have to be done in two steps, at minimum, one to set the series name and on to set the index number, or is there a way to set both fields in one swell loop?

07-23-2022, 01:03 PM	#1
lbutlr Enthusiast Posts: 31 Karma: 103134 Join Date: Feb 2010 Device: iPhone	Searching and replacing in different fields I imported some books that had titles like “Name of Series 01 Title of First book in series”. I tried to use the multi-edit find and replace to set the series name and index number and was able to do so. I ended up doing it by hand, but I am curious if this is possible. First, I searched title for (\d\d) and tried to set the index number to \1 but got a string conversion error. I am guessing that Calibre did not like the ’01’ and that I would need to somehow get a ‘1’ and also get a ’11’, but I didn’t have time to figure out the regex for that… ([1-9]?\d) maybe?) Also, it looks like this would have to be done in two steps, at minimum, one to set the series name and on to set the index number, or is there a way to set both fields in one swell loop?