coloring row by isbn

[igorius]

I hope this thread is the right one for my question:
I want to color #isbn by their numbers:
When isbn begins with 978 -> red
When isbn begins with 979 -> blue
any other isbn (starting with 0* to <978) -> green
Example
I have tried with "contains 978" , but when an isbn contains whereever that 978, coloring is wrong.
So what i am missing is a kind of "begins with"
Is there any way to achieve that in a resonable way?
I tried with regex too, but didnt work too.

[un_pogaz]

substr() could be useful.

Here are some rules to color the ISBN as you want.
Maybe it's possible to make a not "advanced" versions of the rules, but in the meantime, this will do.

begins with 978 (ISBN-10 format 13)

program: test(strlen($#isbn)>10, cmp(substr($#isbn, 0, 3), 979, '', '#0af', ''), '')

begins with 979 (ISBN-13)

program: test(strlen($#isbn)>10, cmp(substr($#isbn, 0, 3), 978, '', '#f00', ''), '')

other isbn (ISBN-10 old format)

program: test($#isbn, '#5a7', '')

Note: important to put the rule "other isbn" after the others, otherwise all ISBN will be green.

[igorius]

ok, that was my problem: I didnt know about the "program: " statement at the beginning of my rule.
I think, by doing for "old" isbns test(strlen($#isbn)<=10, it would go, but unfortunately i have some strange isbns like 4038858104508, which would stay black...
Hmmm, maybe not so bad.
Yep, works!

Thank you very much, you made my day and i learned something new!

[Quoth]

For general info
https://bookscouter.com/blog/isbn-prefix-979-explained/

I'd not heard of ISBN 979 series.

[theducks]

Originally Posted by Quoth

For general info
https://bookscouter.com/blog/isbn-prefix-979-explained/

I'd not heard of ISBN 979 series.

I thought 979 was the overflow of 978 (my chart of EAN/Bookman codes show these as valid for Point of sale). Have I seen one in the wild (USA)? Nope.
What Wikipedia shows:

Within the 979 prefix element, the registration group 0 is reserved for compatibility with International Standard Music Numbers (ISMNs),

It always amazes me on what folk find that they need to highlight in their Library. Different strokes... I would have thought that those (both EAN) would be treated the same, and have highlighted the older ISBN 10,
as always YMMV

[Quoth]

I'd only worry about ISBN when publishing, or if running a bookshop. They are annoying in a library system as different ISBNs sometimes have EXACTLY the same content and it's only the size of the book, paperback, hardback and ebook versions, all of which MUST have a different ISBN, because the 13 digit ones are ALSO UPC/IPC for retail sales.
A different ISBN doesn't tell you on it's own if it's a revised version, only metadata in a database or looking at copyright page tells you that.

[Quoth]

Originally Posted by theducks

I thought 979 was the overflow of 978 (my chart of EAN/Bookman codes show these as valid for Point of sale).

Yes, really that's what it is. The first three digits of UPC/EAN 13 retail code are a GS1 country code
978 was Bookland
Now 979 is also Bookland!

https://en.wikipedia.org/wiki/List_of_GS1_country_codes

[igorius]

I have seen the 979 only from amazon-books, this is why i want them separated from the "typical suspects". And i have a lot of old books which dont have ISBN: Books from GDR, all books older than somewhen in the 50s. And sometimes a new book comes out as kindle-only and later the autor sells these books as printed book. And we know amazon never "buys" isbns for their electronic books, only for printed ones. So i have to wait to get an isbn for these books. Coloring helps much to get directly the state of that books.
Other thing with isbn: When you dont have an isbn for a (new) printed book, you cannot sell these in shops, i _only_ can buy when i show that i am over eighteen in age. Look at festa (german publisher), they have a section called "festa-extrem" most books dont have any isbn: no open selling! You even cannot buy these books used in the wild from shops or online-shops. You only get them via the bay or other private selling sites.
(I have been working some time in a book-shop, so isbn is the most important thing for me to distinguish books! On the other hand i find it interesting that long time ago (isbn-10 times) some isbns were given to different books, say you can find 2 books with different titles and autors but the same isbn)

[theducks]

Originally Posted by igorius

(I have been working some time in a book-shop, so isbn is the most important thing for me to distinguish books! On the other hand i find it interesting that long time ago (isbn-10 times) some isbns were given to different books, say you can find 2 books with different titles and autors but the same isbn)

1 of 2 things.

1) A long time ago, I received an order from a publisher. I received orders using the barcode. Fail. 'No open PO' with that ISBN13.
It also turns out that I stocked another book with the same (was correct) barcode, which would have been really bad as reorders were done from sales reports. Turns out the print run had to be over stickered. ERRORS Happen.

2) Faked ISBN to avoid paying the fee (vanity press published). I used to install grocery checkout systems. I recieved a complaint about a new store having trouble building the PLU table:Not allowed or Exists (or worse).
Turns out a lot of imported from Asian sources had faked the barcode.
(The worse was they faked in the wrong series: Variable weight group: Like used in the deli section)

[jhowell]

Originally Posted by theducks

(The worse was they faked in the wrong series: Variable weight group: Like used in the deli section)

Selling books by the pound. I like it!

[theducks]

Originally Posted by jhowell

Selling books by the pound. I like it!

L RON?

[igorius]

I found a site about that double-isbns:

https://infobib.de/2011/03/01/beispi...ergebene-isbn/

With exactly the book from ben bova i had that problem first!

[Quoth]

Originally Posted by igorius

I have seen the 979 only from amazon-books,

979 is mostly newer USA bought blocks of ISBNs. Amazon is one of the more recent USA publishers.

[davidfor]

Originally Posted by jhowell

Selling books by the pound. I like it!

As a lot of writers were paid by the word, selling a book by weight is not that unreasonable.

[ownedbycats]

Originally Posted by igorius

I have seen the 979 only from amazon-books, this is why i want them separated from the "typical suspects". And i have a lot of old books which dont have ISBN: Books from GDR, all books older than somewhen in the 50s.

ISBN was introduced in 1970, though I've occasionally seen reprints of books from the 50s or 60s to include one.