>- see footer for list info -< Can't work out the precise code, but you should be able to do a regex replace whereby every letter that follows another letter should go lower case (hence every letter that follows punctuation / whitespace will be capitals), then replace And with and, Of with of etc - Should be able to make a good stab at working out the list of words that should remain lowercase, although make sure you ignore the first word when doing this.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of RichL Sent: 22 November 2006 11:03 To: cfdev Subject: [CF-Dev] Countries To proper case >- see footer for list info -< Hi Guys I have a country reference table where all of the country names are held in upper case. I want to be able to output in lower case but keep the caps where appropriate (e.g. UNITED KINGDOM to United Kingdom). However I think that this going to be close to impossible as there are values such as: VIRGIN ISLANDS (BRITISH) VIRGIN ISLANDS (U.S.) WALLIS AND FUTANA So using a function to capitalise the first letter of each word won't really work. How have people approached this situation and has anybody found any good solution? Also, is there a UDF around for capitalising the first letter of each word? Thanks in advance -- Rich _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
