Tell me more ×
Libraries & Information Science Stack Exchange is a question and answer site for librarians and library professionals. It's 100% free, no registration required.
up vote 4 down vote favorite

I'm looking for something that can help with my awful reporting interface.

Has anyone created a macro or a program that will strip out internal spaces, except for the space before the date and recognize all of the different ways in which LoC call numbers can appear, creating a list in shelf order?

In short, I need to normalize my LC call number data.

share|improve this question
Are you looking for code? I'm not sure that will be on topic here, but see what others think. If you had something that you had started, you could present it as a question on SO or DBA.SE, which I think have a firmer basis with normalization and regex. – jonsca♦ Jul 9 '12 at 8:28

1 Answer

up vote 7 down vote

Short answer: it's really, really hard. LC Call Numbers are a freakin' mess.

Check out this discussion for some links to existing code.

http://www.libcatcode.org/questions/5/normalized-lcc-for-sorting

share|improve this answer
as there are only a few links of significance in that discussion (to the Perl, Perl/Python and Java code), you may want to reproduce them here, just in case the intermediary site should disappear. – Joe Jul 9 '12 at 17:23
Thanks. I've been perusing code4lib and the limited options out there, and I think a python parser may be the only option. That's a larger job than I can tackle right now. – Brett Jul 10 '12 at 8:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.