![]() |
#1 |
Junior Member
![]() Posts: 1
Karma: 10
Join Date: Mar 2020
Device: asus
|
![]()
When attempting to update the identifier field in the metadata of a single book, I somehow added an incorrect isbn number to ALL of the books in my library. The result is that when looking at the 'ISBN' column on the main page, I see two isbn's joined as one <for ex 97800624530069780307496195> When opening up the individual 'edit metadata' window only the correct number 9780307496195 is visible but he errant isbn number is nowhere to be found. The errant ISBN (9780062453006) precedes all of the books (about 6000) in the library.
So, to sum up, I would like to delete the errant number for all of the mistaken occurrences. If any idea available, help would be greatly appreciated. Thank you! |
![]() |
![]() |
![]() |
#2 |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 30,281
Karma: 57979022
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
BACKUP your Library before attempting
Bulk mode Search & Replace (S&R) might be the solution Select all (or a few to test) bad books: Tap the 'E' (edit metadata Bulk mode): Switch to the S&R tab: Regular Expression mode, replace field Search field: Identifiers (form adjusts for context) Validate that the test samples (right) look saneIdentifier type: isbn: Search for: 9780062453006\s*(\d+) Replace with: \1 The theory (plan ![]() Looks for ISBN starting with 9780062453006 (optional space) and captures the remaining digits. The replace sets the ISBN to those captured |
![]() |
![]() |
![]() |
#3 |
null operator (he/him)
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 20,857
Karma: 27620684
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
![]() And, if you to it regularly you could just restore it if/when something like this happens again, which it probably won't -- because you've have a backup ![]() Once you have the first copy, a daily incremental update typically takes a couple of minutes. BR |
![]() |
![]() |
![]() |
Tags |
bulk delete, isbn, metadata |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
sonybookid: identifier defunct? | Vortex | Library Management | 8 | 04-10-2016 10:51 AM |
Search identifier needed | Fbone | Calibre | 5 | 10-16-2015 08:46 PM |
Copy data from Title field to IDs field | rlh3 | Library Management | 9 | 09-24-2012 08:12 AM |
Field of Life and Field of Mind | newone | Self-Promotions by Authors and Publishers | 1 | 07-23-2012 02:21 AM |
Default value for read field (Yes/No-field) | opitzs | Library Management | 3 | 11-09-2011 07:17 AM |