Re: Need help to convert a name in upper case, to mixed case

On Mon, Jan 14, 2019 at 2:36 PM Tyler, Matt <matt.tyler@xxxxxxxxxxxxxx>
wrote:

How does Python convert to proper case MCDONALD or MACDONALD, etal.? The
code I gave out we use and we know that it has this limitation.

Well, any code in any language to deal with English capitalization of
proper names is going to need a dictionary structure of some sort. Python
presents such structures, which you'll need to populate and create/borrow
some code that looks 'em up.

There's no algorithm other than dictionary lookup that's going to
distinguish between the separate cases of

MacDonald
versus
Mackenzie

Plus, the tool I sent gives me the ability to wrap it in an external SQL
procedure. How would Python accomplish this?

If you can call a CL passing parameters, you can call Python with those
params, because you can call Python from a CL.