Re: Converting names & street names

Unfortunately Booth - it is NOT a one time deal. Our customer base grows in
leaps and bounds day by day.



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx

midrange-l-bounces@xxxxxxxxxxxx wrote on 08/30/2006 04:41:19 PM:

How many total names in the file, and is this a one-time change-over?

It is amazing how fast a good operator can go through a thousand names,
if you present them for her/him to read & change easily on the screen.

If its a one time deal, a brute force solution may be a lot cheaper and
quicker in the end.



Scott Klement wrote:

Thanks for your reply Tommy, but the main problem I am going to have

is

with the names like O'Donnell McGuyver etc where the name contains

more

than one upper case character.

Even worse is something  like "Herman Van der Staey".  In that case the

last name is 3 words, and one of them isn't capitalized, but the others

are.  I can't think of an algorithm that would understand how to

properly

capitalize all names.

The truth is, names don't follow a set pattern for capitalization. You
have to deall with them on a case-by-case basis.  So you'd almost need

a

database of every possible name and how it's capitalized....  or at

least

a database of the ones that don't follow the rule of "first letter of
every word."   This wouldn't be a minor undertaking.

I suggest looking for a commercial package unless a "close enough"

routine

is acceptable.

--
-----------------------------
Booth Martin
www.martinvt.com
-----------------------------
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.