Regular Expression Help for Importing ISBN

nickmik123 · 07-05-2018, 06:29 PM

I have a number of books that have the following naming methodology or something similar to it: Romer D. Advanced Macroeconomics (MGH, 1996)(T)(ISBN 0070536678)(T)(550s) GK - Unknown. What RegEx code could be used to either 1) edit metadata in bulk by search in title and apply to identifier or 2) re-importing the books with the appropriate settings so that Calibre looks for the ISBN in the document title? Would the simplest solution be to rename all the files outside Calibre just to the ISBN, since I can do this quickly, and then re-import (I'm guessing the RegEx is less complicated for this)?

Thanks for any help or suggestions.

Divingduck · 07-07-2018, 06:34 AM

One way is selecting books in the library ->Edit metadata in bulk

Search field: title
Search for: (.*)ISBN\s([0-9,-]+)(.*)
Replace with: \2
Destination field: identifiers
Identifier type: isbn
Search mode: Regular expression

Attention: You can't reverse this action. Maybe good idea to have a backup in case...
Test it first on some books and verify the results before you use it for mass changes

An other way is to use an import template for adding books into the library.

07-05-2018, 06:29 PM	#1
nickmik123 Junior Member Posts: 3 Karma: 10 Join Date: May 2018 Device: none	Regular Expression Help for Importing ISBN I have a number of books that have the following naming methodology or something similar to it: Romer D. Advanced Macroeconomics (MGH, 1996)(T)(ISBN 0070536678)(T)(550s) GK - Unknown. What RegEx code could be used to either 1) edit metadata in bulk by search in title and apply to identifier or 2) re-importing the books with the appropriate settings so that Calibre looks for the ISBN in the document title? Would the simplest solution be to rename all the files outside Calibre just to the ISBN, since I can do this quickly, and then re-import (I'm guessing the RegEx is less complicated for this)? Thanks for any help or suggestions.

07-07-2018, 06:34 AM	#2
Divingduck Wizard Posts: 1,166 Karma: 1410083 Join Date: Nov 2010 Location: Germany Device: Sony PRS-650	One way is selecting books in the library ->Edit metadata in bulk Search field: title Search for: (.)ISBN\s([0-9,-]+)(.) Replace with: \2 Destination field: identifiers Identifier type: isbn Search mode: Regular expression Attention: You can't reverse this action. Maybe good idea to have a backup in case... Test it first on some books and verify the results before you use it for mass changes An other way is to use an import template for adding books into the library. Attached Thumbnails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Please help me with regular expression :help:	Tatjana	Library Management	2	05-30-2014 05:41 PM
Regular Expression Help	iKarampa	Calibre	13	12-15-2010 07:17 AM
Regular Expression Help	smartmart	Calibre	5	10-17-2010 05:19 AM
Helping importing books using regular expression	askyn	Calibre	4	05-08-2010 01:06 AM
regular expression - importing vs testing	pbj	Calibre	5	02-09-2010 03:02 PM

Advert