View Single Post
Old 06-03-2014, 12:24 AM   #9
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,475
Karma: 8025702
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by Tatjana View Post
It is possible at this time, using latest Version of Calibre for Windows (1.39) get rid of Identifiers that do not have a identifier prefix?

example: isbn:9780310231202, 0310231205:0310231205

Is it possiible to get rid of all identifiers that do not have a prefix like "isbn:", "amazon:" etc?
Please note the example above has a "junk prefix "0310231205:"

If it is not possible to this on Calibre right now, is there any free sqlite database editor what would allow me to do this?

Thank you very much in advance for any help.
Probably the best you can do in calibre, and also I suspect in an SQL db utility, is to keep identifiers if they are in a good identifiers list. However, if you can figure out a regexp (or something) that is guaranteed to match a junk identifier but not a good one then you could do that.

The "good list" technique would use the template approach above to select out the ones you wish to keep.
chaley is offline   Reply With Quote