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

[Bigwood, David]

Melissa,

The Library of Congress recently made much of their catalog available for download. Terry Reese grabbed it and put it on GitHub. https://github.com/reeset/lc_data_dump You could download that  then extract all the 050s from it using MarcEdit or another tool.  That should give you plenty of data to test, millions of instances.

David Bigwood
dbigwood at hou.usra.edu<mailto:dbigwood at hou.usra.edu>
Lunar and Planetary Institute

From: Eril-l [mailto:eril-l-bounces at lists.eril-l.org] On Behalf Of Melissa Belvadi
Sent: Monday, May 29, 2017 12:19 PM
To: eril-l at lists.eril-l.org
Subject: [Eril-l] Google sheets script function for sorting by LC call number

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<mailto: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/20170530/f34f1301/attachment-0001.html>