Re: Converting names & street names -- MIDRANGE-L

Some where along the line some one enters the name. Going forward, itcould be entered correctly at the time of entry. The idea of anauxiliary file for properly cased name and address seems like anon-going burden. It would seem reasonable at some point to make adecision to proper-case names & addresses. including street, city, &state. There are a lot of reasons for making a change-over, and veryfew that I can think of to stay with the constraints of a 132-hammerprinter.

I say this because of always finding that in the end, solving itprogramatically never really solved the headache. Some day the boss'swife's mother's best friend is going to be insulted, and that is notgoing to ever be a good day.




Alan Shore wrote:

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

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.