AnsweredAssumed Answered

Replace field contents ALL-CAPS to Single caps

Question asked by tkemmere on Dec 3, 2015
Latest reply on Dec 3, 2015 by 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.

Outcomes