ISBN from Book Title

Jamamkaase · 09-14-2014, 03:41 PM

Hi,

can be banal, but I cannot figure it out and I could not find it really covered in old posts

ISBN is in titles of already imported into the library books (not in a file name)
ISBN, 10 or 13 digits, is contained within the title text string (not just isbn no., and not at the beginning, not following a specific pattern, but often (again, not only) after "ISBN")

e.g.
Author - Title of the Book - 0123456789
Book title, Autor, edition, year, isbn 0123456789
(0123456789) BookTitle
BookTitle, ISBN-0123456789, some@rubbish
or any similar combination

I am trying to use Search and Replace in Bulk editing, using Regular expressions, by trial and error method, mostly error... with no success
However, I did partially succeed some time ago, but have changed pc since and naturally lost the old config (recoverable, if only knew where to look for this specific setting)

I do not need to add that I have no clue, and cannot grasp, Regular Expressions. Sheer luck is not with me this time

Any help, please? What is the magic string?

BetterRed · 09-14-2014, 06:10 PM

@Jamamkaase - maybe this [GUI Plugin] Extract ISBN (← click) does what you want to do.

BR

Jamamkaase · 10-11-2014, 09:53 AM

Extract ISBN is great, but for some reason it does not do the obvious - i.e. extracting ISBN from the _file_name_

theducks · 10-11-2014, 10:17 AM

Quote:

Originally Posted by Jamamkaase

Extract ISBN is great, but for some reason it does not do the obvious - i.e. extracting ISBN from the _file_name_

The normal Adding Books Xpath (when reading metadata from file name) can do that.

The file name can/will be modified during the ADD process

This PI is for getting ISBN from inside a book

DaltonST · 11-16-2014, 02:37 PM

@Jamamkaase,

Your problem is a trivial one to solve if use use the Quarantine And Scrub add-on/plug-in. Book Level Scrubbing will extract a valid ISBN (must have a valid checkdigit) from Author, Title, and Tags and relocate it to the ISBN column.

DaltonST

gabigabigabi · 11-17-2014, 05:01 PM

Hi there! Don't know if my trick is going to help, but I've added in the file name the title and the ISBN.
For example, White Fang-0123456789.pdf
Then, in the automated adding function, i've written the following expression:
(?P<title>.+)-(?P<isbn>\d+)

And the title and the ISBN goes each one in the appropriate column.

Hote that helps (and sorry for my bad english ;-) )

Cheers

09-14-2014, 03:41 PM	#1
Jamamkaase Junior Member Posts: 2 Karma: 10 Join Date: Sep 2014 Device: pc	ISBN from Book Title Hi, can be banal, but I cannot figure it out and I could not find it really covered in old posts ISBN is in titles of already imported into the library books (not in a file name) ISBN, 10 or 13 digits, is contained within the title text string (not just isbn no., and not at the beginning, not following a specific pattern, but often (again, not only) after "ISBN") e.g. Author - Title of the Book - 0123456789 Book title, Autor, edition, year, isbn 0123456789 (0123456789) BookTitle BookTitle, ISBN-0123456789, some@rubbish or any similar combination I am trying to use Search and Replace in Bulk editing, using Regular expressions, by trial and error method, mostly error... with no success However, I did partially succeed some time ago, but have changed pc since and naturally lost the old config (recoverable, if only knew where to look for this specific setting) I do not need to add that I have no clue, and cannot grasp, Regular Expressions. Sheer luck is not with me this time Any help, please? What is the magic string?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to clean ISBN book title	jpottsx1	Library Management	0	08-23-2013 08:50 PM
Title To ISBN after adding books	Giuseppe Chillem	Calibre	6	01-07-2013 12:00 AM
How to swap title with identifiers:isbn	tizboy	Library Management	1	06-06-2012 08:48 PM
Getting ISBN from PDF book	uott299	Library Management	2	03-01-2011 03:01 PM
ISBN look up, usually missing part of title	thibaulthalpern	Calibre	7	05-06-2009 01:57 AM

09-14-2014, 06:10 PM	#2
BetterRed null operator (he/him) Posts: 20,572 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	@Jamamkaase - maybe this [GUI Plugin] Extract ISBN (← click) does what you want to do. BR

10-11-2014, 09:53 AM	#3
Jamamkaase Junior Member Posts: 2 Karma: 10 Join Date: Sep 2014 Device: pc	Extract ISBN is great, but for some reason it does not do the obvious - i.e. extracting ISBN from the _file_name_

11-16-2014, 02:37 PM	#5
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	@Jamamkaase, Your problem is a trivial one to solve if use use the Quarantine And Scrub add-on/plug-in. Book Level Scrubbing will extract a valid ISBN (must have a valid checkdigit) from Author, Title, and Tags and relocate it to the ISBN column. DaltonST

11-17-2014, 05:01 PM	#6
gabigabigabi Junior Member Posts: 4 Karma: 10 Join Date: Aug 2014 Device: none	Hi there! Don't know if my trick is going to help, but I've added in the file name the title and the ISBN. For example, White Fang-0123456789.pdf Then, in the automated adding function, i've written the following expression: (?P<title>.+)-(?P<isbn>\d+) And the title and the ISBN goes each one in the appropriate column. Hote that helps (and sorry for my bad english ;-) ) Cheers

Advert

Advert