I would think if you’re looking for a remedy solution, the easiest thing would be set it all to LOWER first and then work out which letters need to be capitalised. The first letter is easy, then you want to find the location of a space character and UPPER the letter after that, and same again for O’… however Mc/Mac names are more tricky as some people are MacKay while others are Mackay for example. There is no failsafe way to do that.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: 22 April 2016 15:39 To: arslist@ARSLIST.ORG Subject: Re: Proper Case ** 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" <only1sa...@gmail.com<mailto:only1sa...@gmail.com>> wrote: ** I could only find Upper and Lower. Nothing about Proper Case. On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook <remedyr...@gmail.com<mailto:remedyr...@gmail.com>> 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" <only1sa...@gmail.com<mailto: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_ _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_ Glasgow - UK Council of the Year 2015 ***Disclaimer**** This e-mail and any attachments are for the intended addressee(s) only and may contain confidential and/or privileged material. If you are not a named addressee, do not use, retain or disclose such information. This email is not guaranteed to be free from viruses and does not bind Access in any contract or obligation. SERVICE GLASGOW LLP trading as ACCESS Registered in Scotland. No: SO301705 Registered Office: 220 High Street, Glasgow, G4 0QW _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"