Mass metadata edit

[markminnich]

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]

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.