You will have to sequence the string functions. Use one to identify the first character of each field, then another to ensure that the is upper case. Then the next one will ensure that the rest are lower case.
Rick On Apr 22, 2016 7:35 AM, "Satya Miller" <[email protected]> wrote: > ** > I could only find Upper and Lower. Nothing about Proper Case. > > On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook <[email protected]> wrote: > >> ** >> >> 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" <[email protected]> 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_ >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _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"
