Mass metadata edit

markminnich · 06-23-2021, 08:38 PM

Hello,

I am trying to go through a selection of book entries and weed out an issue with the id field.

I add some books to my library and some have an I’d of,
Mobi-asin:numbers
I want to change I’d values to,
Asin:numbers

Basically remove the mobi- portion. I have tried using Calibre normal expression or REGEX mode but can’t get either to work. I am inexperienced with REGEX. I know I am doing something wrong but would appreciate any help.

Initially I submitted the question to refitted /rcalibre they suggested some things, none of which worked.

Thanks bunches!

un_pogaz · 06-26-2021, 06:51 AM

With a little trickery all can be done in one operation Search/Replace

Search field: {template}
Template: {identifiers}
Search for: (.*)(?:mobi-asin|amazon(?:_\w+)?):(B\w+)(.*)
Replace with: \1asin:\2\3
Target field: identifiers
Target identifier: *

Also I advise you the Mass Search/Replace plugin which will allow you to save and to redo quickly and easily this operation.

06-23-2021, 08:38 PM	#1
markminnich Junior Member Posts: 2 Karma: 10 Join Date: Jun 2021 Location: Columbus, OH Device: iPad	Mass metadata edit Hello, I am trying to go through a selection of book entries and weed out an issue with the id field. I add some books to my library and some have an I’d of, Mobi-asin:numbers I want to change I’d values to, Asin:numbers Basically remove the mobi- portion. I have tried using Calibre normal expression or REGEX mode but can’t get either to work. I am inexperienced with REGEX. I know I am doing something wrong but would appreciate any help. Initially I submitted the question to refitted /rcalibre they suggested some things, none of which worked. Thanks bunches!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Edit Title Field in Edit Metadata window	goldilocks	Library Management	7	11-08-2015 10:09 PM
Edit books: Mass warnings. Bulk correction?	chaot	Editor	6	10-22-2015 07:54 AM
Mass metadata enhancement	DirkDirkson	Calibre	10	05-28-2015 08:29 AM
Mass editing of metadata fails under Linux	Nightfairy	Library Management	8	12-10-2014 03:13 PM

06-26-2021, 06:51 AM	#2
un_pogaz Chalut o/ Posts: 486 Karma: 678910 Join Date: Dec 2017 Device: Kobo	With a little trickery all can be done in one operation Search/Replace Search field: {template} Template: {identifiers} Search for: *(.)(?:mobi-asin\|amazon(?:_\w+)?):(B\w+)(.)* Replace with: \1asin:\2\3 Target field: identifiers Target identifier: * Also I advise you the Mass Search/Replace plugin which will allow you to save and to redo quickly and easily this operation.