On Fri, 4 Jul 2008 15:48:50 -0700 (PDT), Jamenson wrote:
> Hi everyone!
>
> I want to convert strings like "LEONARDO DI CAPRIO" to "Leonardo di
> Caprio". The function StrConv converts to "Leonardo Di Caprio" and we
> think it is innapropriated.
>
> Any help appreciated.
>
> Thank you!
You'll have to create a User Defined Function using StrConv() and a
look-up table to find names with these different kinds of
capitalizations, i.e. McDonald, O'Brien, Smith-Jones, van den Steen,
etc.,
or .....
manually search and change these relatively few oddball
miss-capitalizations.
Be aware, also, that sometimes the same name can be capitalized
differently. McDaniels and Mcdaniels are both correct.
Of course the best method is correct data entry. <g>
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
|
