RE: Converting names & street names

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.
When I worked on a mainframe, using COBOL, we had to do the same thing in
converting from upper case to mixed case, and we ended up with literally
THOUSANDS of names like these that did not fit a straight conversion. These
we had to place in a special file to cross-reference them to how they
should be printed on a letter.
Now this was more years ago than I care to remember, and the mainframe (and
the bank) no longer exist.
I admit, I AM being lazy, and if I had to, I could go through the routine
of re-creating this special file on the AS/400 (or i5, i-series or whatever
its now called) but if someone already has this available (and is willing
to share) ............

Thanks


Alan Shore

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

midrange-l-bounces@xxxxxxxxxxxx wrote on 08/30/2006 03:57:17 PM:

I have run this for a long time so I'm not sure what state it's
in....but it should be a good start.


Thanks,
Tommy Holden


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Wednesday, August 30, 2006 2:53 PM
To: Midrange Systems Technical Discussion
Subject: Converting names & street names

Afternoon all,
we hold our customer name and address in upper case. We want to create
letters to these customers, but we want to convert the name and address
to
mixed case, so that the name looks like

SMITH             converts to       Smith
which is fairly straight forward, however,
O'DONELL    converts to       O'Donell
MCGUYVER    converts to McGuyver
plus others could provide problems.
My question is :-
does anyone have/know of a routine and/or 3rd party vendor that would
handle the conversion of names and addresses from upper case to mixed
case?

Thanks in advance



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
--
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.

[attachment "cvtchar.txt" deleted by Alan Shore/NBTY] --
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.