Hello all! My original imported data had all of the subject headings in CAPITAL LETTERS and all of my new headings are "proper" (first letter is capitalized and that's it). I know in EXCEL there is a PROPER command that converts ALL CAPS to the proper 'All caps'. Is there a command in SQL to convert my all CAPS subject heading to proper? Or Koha? Thanks in advance for any help!
Hartman, David W. - GBTS Library schreef op wo 23-11-2011 om 10:07 [-0500]:
Is there a command in SQL to convert my all CAPS subject heading to proper? Or Koha? Thanks in advance for any help!
There is 'lower' and 'upper', but I'm not aware of anything in MySQL which does the equivalent of 'proper'. Also, I think the subjects are in MARC rather than a database table, in which case it'd be hard to do from plain sql anyway. It might be necessary to write a small perl script to do it. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
participants (2)
-
Hartman, David W. - GBTS Library -
Robin Sheat