I have a field of street names in all caps. Some of the names begin with numbers i.e. 9TH ST. I need to put the names into proper case. I've tried various versions of code but they haven't worked. I think it's getting tripped up on the leading number thing. I assume I need code that will check for a number and skip over it if it finds one and then continue with case changes, but I don't know how to write it. Any ideas would be appreciated.
If you like Python, how about the titlecase module? http://muffinresearch.co.uk/archives/2008/05/27/titlecasepy-titlecase-in-python/
It's decent, and works for English. Of course there will always be exceptions or gray areas (see my comment under the question above).