StrConv

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

I want to convert names to proper case. I'm running into a problem with
names like MacDonald, McDoogle, O'Connor, etc. The 3 character is converted
to lower case. Does anyone know of a function or a way to keep them caps? Is
it just a matter of comparing strings? I kind of doubt the phone book
companies rely on comparing.

thanks!
 
And there are names from some foreign languages where the first letters are
not capitalized, and there is more than one "word" in the last name: de
Shazar.

If you want to get all these correct (if there is any one correct way for
them, which there may not be) you must put all of them in a table the way
you want them. No program based on "rules" is going to get them all
correct.
 
Back
Top