The string functions should be able to do that. Look in the appendix of your AR System documents.
Rick On Apr 22, 2016 7:21 AM, "Satya Miller" <only1sa...@gmail.com> wrote: > ** > Morning! > > I was hoping someone has an idea to help me with something. I have a form > that has two fields (First Name and Last Name) in it. The data is not > "clean." I need to convert the data in these two fields to Proper Case. > In other words, capitalize each word, or if possible even Capitalize > correctly like O'Connell. I searched the ARSList and the last suggestion > was from 2005. I was hoping there might be a better solution now. > > Thanks in advance for you help. > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"