[Eril-l] Google sheets script function for sorting by LC call number

Melissa Belvadi mbelvadi at upei.ca
Mon May 29 10:18:57 PDT 2017


Hello, all.

I've just written and shared in github a function script specifically for
Google Sheets that is designed to be used in a sheet that has normal (that
is, unsortable) LC call numbers and  provides a properly sortable column
(mostly by padding the various numbers with leading zeros).

It is located here:
https://github.com/mbelvadi2/lcsortable

The readme has the basic directions on how to use it.

It works on a spreadsheet with all of my own catalogue's lc call numbers,
but there may be legitimate variants of LC call number syntax that I'm
unaware of that I might have failed to code properly for. (It does handle
3-letter LC classes and those weird old call numbers that start with the
class and then have the pubyear instead of subject area number.)

So I could sure use either some direct help testing this or some big lists
of LC call numbers that may include unusual but legitimate forms of LC call
numbers.

If anyone has pretty comprehensive test lists of LC call numbers, I'd
appreciate your sharing it with me.

Otherwise, I think this is good to go and you all are welcome to use it.
If you do use it, I'd love it if you dropped me a line to let me know about
it, just to know it is helpful. I put the "MIT license" on it for maximal
sharing as per github's advice.

Also this is my first serious use of github, so if I messed up anything to
do with that, please advise me.

-- 
Melissa Belvadi
Collections Librarian
University of Prince Edward Island
mbelvadi at upei.ca 902-566-0581
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20170529/4f7994c7/attachment.html>


More information about the Eril-l mailing list