Sometimes the intersection of Libraries and Technology has a 10-car pileup

[deborah]

I'm currently trying to normalize and shift into comma separated values files the disambiguated name lists created by four different students who don't work for my department, with whom I'm not allowed to communicate, and for whom I'm not allowed to create standard documentation. (Don't ask.) After title casing everything, my current (incomplete) Vim regular expression is: (screenreader users be warned you should skip!)

:%s#\(<\([^>]*\)>\( \)\)*\(\(\((\)*\([^)]*\)\()\)*\) \([^{]*\)\)#\2,\7,\9,,,,,,,,,\2\3\7 \9;,MS165.001.010.00001


Yes, this is what happens when the people dealing with metadata that need to be normalized are not being managed by professionals.

(I'm doing this in Vim instead of in Perl because each file is a little bit different, so every time I open one I'm doing some hand manipulation of the data and massaging the regular expression slightly to accommodate the fact that each of the students copes with variant names, titles, and unknown personal or surnames differently.)

This is why we can't have nice things.

Comments

[deborah]

o_O

How do you even do that? What metadata did they give you?

(Actually, we have a huge set of photographs where we are going to be extracting all of the metadata from the EXIF embedded metadata, and instead of titles there are lengthy descriptions of each photo set. But that's different. At least there we can have students synthesize what they see with the lengthy description to extrapolate meaningful brief titles.)

[libskrat]

They gave me a "keywords" field which had (variously) something title-ish that wasn't in any way demarcated from a description of varying length (from zero to...), as well as EVERY FREAKING THING THAT WAS IN THE OTHER FIELDS.

SHOOT. ME. NOW.

[jeshyr]

Let me get this right, you people chose this profession?

Do they hide the details until you graduate and are hired, or were you both on the Really Good Drugs?

Ricky
(who might, under duress, admit that the vim regular expression ... or the fact that other people do stuff like that ... was really hot, in a geeky way)