Re: Converting names & street names

[Wayne McAlpine <wayne.mcalpine@xxxxxxxxxxxxxxxxx>]

I understand the use of an alternate table and have used this technique 
in several applications.  My point is that if you use a complex set of 
standardized rules to alphabetize records, it's not possible to simply 
convert the case using an alternate collating sequence.  The handling of 
name inversions and punctuation can't be done consistently and still 
have a natural appearing name when it's displayed or printed.

As someone else pointed out, there's a cost associated with doing it 
this way and it's up to the organization to determine if it's worth it.

Lapeyre, Francis wrote:
> To sort, all you need to do is specify a table on the ALTSEQ in a logical
> file:
>
>      A*ARCUS - CUSTOMER MASTER FILE                              
>      A*                                                          
>      A                                      ALTSEQ(*LIBL/ALTTBL) 
>      A          R CUS                       PFILE(ARCUS)         
>      A*                                                          
>      A          K CUSLNM                                         
>      A          K CUSFNM                                         
>      A          K CUSNO                                          
>
> Putting an upper-case only field in the file just to sort by is not
> necessary.
>
> Francis Lapeyre
> IS Dept. Programmer/Analyst
> Stewart Enterprises, Inc.
> E-mail: flapeyre@xxxxxxxx 
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wayne McAlpine
> Sent: Wednesday, August 30, 2006 3:35 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: Converting names & street names
>
> Another case for including both sort name and display name fields in the 
> file.
>
> Alan Shore 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.
> > 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.