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

    Replace field contents ALL-CAPS to Single caps


      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!