- see footer for list info -<
Regex might work. Except not CF regex, but if you can use the Java one you might be able to replace: /([^[:alpha:]])([[:alpha:]])([[:alpha:]]+)/i with \1\u\2\L\3\E
Which I think would do what you want, but I'm not certain (and haven't tested it at all) On 11/22/06, RichL <[EMAIL PROTECTED]> wrote:
>- 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 -<
-- \ \ Peter Boughton blog.bpsite.net / / _______________________________________________ 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 -<
