3 Replies Latest reply on Dec 3, 2015 4:06 AM by tkemmere

    Replace field contents ALL-CAPS to Single caps

    tkemmere

      Dear all,

       

      Probably a simple question for the seasoned users:

       

      I have a large number of entries in the field FamilyName all spelled in ALL-CAPS. (Like my name would be KEMMERE). I'd like to make them just with a single capital letter, the first one. (So Kemmere). I've understood that the menu Records > Replace Field Contents... is useful to use. But I can't figure out the calculation to use for this. I got this far:

      Left (FamilyName;1)&

      But how do I destill the right-but-one-characters of the names?

       

      Thanks in advance!

      Thomas.