Search to find ISBN-10s

ownedbycats · 10-07-2022, 05:32 PM

I have a saved search to find books with ISBN-10s with or without dashes:

Code:

identifiers:"=isbn:~^\d{9}(\d{1}|(X|x))$"
OR identifiers:"=isbn:~^\d{1}(-|\s)\d{3}(-|\s)\d{5}(-|\s)(\d{1}|(X|x))$"

However, recently I've found it failing more often - I figure I didn't form the regex very well. Has anybody suggestions for improvements for this?

theducks · 10-07-2022, 06:53 PM

Code:

identifiers:"isbn:[01]"

ISBN 10 does not start with 978

0 or 1 is English language books, adjust first digit for other languages

Quoth · 10-08-2022, 08:18 AM

Yes, 978 and now 979 are EAN/UPC prefixes for ISBN-13, Country Code = Bookland. The ISBN-10 is obsolete and first digit is language. Most ISBN 10 have ISBN-13 equivalents.

Also the elephant in the room is that identical content novels can have different ISBN-10 or ISBN-13 if there is more than one printed format. An ebook need not have an ISBN at all as it's for retail ordering of a paper title in print, not for Library cataloguing or ebook "ordering". Physical libraries may store an ISBN simply as part of a book record. Each copy has a different library index code even if the same edition. If there are 10 copies bought at different times (or large print, hardback, Trade size and pocket book will ALWAYS have different ISBNs) they may not all have the same ISBN.

If you have a Kindle there is some value to an ASIN column, but there is no value at all to an ISBN column for ebooks. I'd only only have an ISBN column if I was operating a physical (lending) library, purely to differentiate editions. A library for printed books would have a row for each copy even if the exact same book.
In the past I programmed and sold library software for physical books and videos.
I might use an ISBN barcode once with a scanner to add a new book record to a library database of physical books. In the past a unique per copy barcode would have been added, now RFIDs are used which can be concealed in hardbacks and also be part of an anti-theft system.

10-07-2022, 05:32 PM	#1
ownedbycats Custom User Title Posts: 10,745 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Search to find ISBN-10s I have a saved search to find books with ISBN-10s with or without dashes: Code: identifiers:"=isbn:~^\d{9}(\d{1}\|(X\|x))$" OR identifiers:"=isbn:~^\d{1}(-\|\s)\d{3}(-\|\s)\d{5}(-\|\s)(\d{1}\|(X\|x))$" However, recently I've found it failing more often - I figure I didn't form the regex very well. Has anybody suggestions for improvements for this?

10-07-2022, 06:53 PM	#2
theducks Well trained by Cats Posts: 30,923 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Code: identifiers:"isbn:[01]" ISBN 10 does not start with 978 0 or 1 is English language books, adjust first digit for other languages

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search for ISBN-10s	ownedbycats	Library Management	19	02-09-2021 11:23 AM
ISBN metadata search issue	Iconoclastica	Library Management	12	04-26-2020 09:46 PM
A search for books with NO ISBN in 'Ids'?	222fbj	Library Management	3	08-06-2016 11:26 AM
Can Calibre automatically find ISBN from files?	samalex	Conversion	2	01-20-2012 09:37 AM
Search on blank ISBN	tilleydog	Calibre	2	07-05-2010 09:27 PM

10-08-2022, 08:18 AM	#3
Quoth Still reading Posts: 13,779 Karma: 103895653 Join Date: Jun 2017 Location: Ireland Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper	Yes, 978 and now 979 are EAN/UPC prefixes for ISBN-13, Country Code = Bookland. The ISBN-10 is obsolete and first digit is language. Most ISBN 10 have ISBN-13 equivalents. Also the elephant in the room is that identical content novels can have different ISBN-10 or ISBN-13 if there is more than one printed format. An ebook need not have an ISBN at all as it's for retail ordering of a paper title in print, not for Library cataloguing or ebook "ordering". Physical libraries may store an ISBN simply as part of a book record. Each copy has a different library index code even if the same edition. If there are 10 copies bought at different times (or large print, hardback, Trade size and pocket book will ALWAYS have different ISBNs) they may not all have the same ISBN. If you have a Kindle there is some value to an ASIN column, but there is no value at all to an ISBN column for ebooks. I'd only only have an ISBN column if I was operating a physical (lending) library, purely to differentiate editions. A library for printed books would have a row for each copy even if the exact same book. In the past I programmed and sold library software for physical books and videos. I might use an ISBN barcode once with a scanner to add a new book record to a library database of physical books. In the past a unique per copy barcode would have been added, now RFIDs are used which can be concealed in hardbacks and also be part of an anti-theft system.

Advert