|
If there is a good business reason on can enter properly cased then force upper case in a paired set of fields quite easily. At 05:38 PM 8/30/2006, Booth Martin wrote:
Some where along the line some one enters the name. Going forward, it could be entered correctly at the time of entry. The idea of an auxiliary file for properly cased name and address seems like an on-going burden. It would seem reasonable at some point to make a decision to proper-case names & addresses. including street, city, & state. There are a lot of reasons for making a change-over, and very few that I can think of to stay with the constraints of a 132-hammer printer. I say this because of always finding that in the end, solving it programatically never really solved the headache. Some day the boss's wife's mother's best friend is going to be insulted, and that is not going 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 > 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. >> -- ----------------------------- 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
