To convert all your Initial Caps titles to sentence case, this technique
may work. Use the Edit Subfield Data tool:

Field: 245
Subfield: a
Find: ( [A-Z])
Replace: $1lcase($+)

This replaces every instance of a capital letter following a space with
its lowercase version, while retaining the space. If the record is
properly formatted, with no space around subfield codes, the expression
will preserve the initial capital letter of the title that follows
delimiter "a". Unfortunately, it will do that for subfield $b also; but
you could easily fix that with a straightforward regular expression.
Since I don't know if all your 245 fields have subfields $a, $b, and $c,
using Terry's Edit Subfield Data tool, working on each subfield
separately, seems like the best answer.

Without having thought it through, I'd assume the same procedure could
work on your 505s.

*****************************************
  Walter F. Nickeson, Catalog &
    Metadata Management Librarian
  Rush Rhees Library
  University of Rochester
  Rochester, NY  14627-0055
  [log in to unmask] 
  (585) 273-2326  fax: (585) 273-1032
*****************************************


> -----Original Message-----
> From: MarcEdit support in technical and instructional matters
> [mailto:[log in to unmask]] On Behalf Of Fox, Chris
> Sent: Tuesday, December 13, 2011 5:35 PM
> To: [log in to unmask]
> Subject: Re: [MARCEDIT-L] using sentence case for 245
> 
> I don't want to change 245 $c because that is already capitalized
correctly.
> My file has 245s that have Initial Capital Letters, not ALL CAPS.
> 
> On Terry's blog (mentioned below), he has the following to change 245
$a
> from ALL CAPS to Initial Caps using the Edit Subfield Data function:
> Field: 245
> 
> Subfield: a
> 
> Find: ([A-Z])([A-Z0-9']+)
> 
> Replace: $1lcase($+)
> 
> If I knew what this meant, I would tweak it so that it changed 245 $a
from
> Initial Caps to Sentence case.  I would then run it to work on all $b.
Or change
> the above regex to change 245 $a (and then $b) all to lower case, and
then I'd
> use your Find/Replace regex below to capitalize the first letter in
245 $a.  Is
> there a way to make this work?
> 
> Thanks,
> Chris

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]