× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. November 2021

Re: [EXTERNAL] Converting upper case names to mixed case names

This is probably not exactly what you want but might get you close. I used
SPLIT and LISTAGG the following...

create table qtemp.testtable
(splitfld char(50))
;

insert into qtemp.testtable
values
('GAIL FAZIO-BROWN'),
('KYRESE DUBOSE'),
('DAVID DESEMPLE')
;

With myfile as (
SELECT RRN(a) therow, upper(substr(Element,1,1)) ||
lower(substr(Element,2)) as thename
FROM qtemp.testtable a
, TABLE(SYSTOOLS.SPLIT(SPLITFLD, ' '))
Where Element > ' ' )
Select listagg(thename, ' ') Within Group(order by therow)
from MyFile
Group by therow
;

Got results of...

Gail Fazio-brown
Kyrese Dubose
David Desemple

Good luck, interesting challenge.

On Tue, Nov 2, 2021 at 5:59 PM Bruce Vining <bruce.vining@xxxxxxxxx> wrote:

I almost responded (and based on what Jon found should add "again").

I would recommend storing the names in the case the end user (customer)
wants and simply having the user (entry person) confirm that the name is
exactly what is needed (we have a program where I'm at right now that does
just this verification for names on contracts -- quite recently added to
the program). To later %upper the mixed case names (so long as you have
your CCSID right) is then easy (to get you back to what you have now -- all
uppercase). Customers can declare their name casing to be pretty much
anything they want... and it's the strange/exception casing users that will
scream the loudest when the algorithm gets it wrong.

On Tue, Nov 2, 2021 at 5:40 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

I didn't notice that Alan - too funny!

I find that if I _know_ I've seen it on midrange that adding site:
archive.midrange.com <http://archive.midrange.com/> will find stuff that
a straight google search will place on page 97!


Jon P.

On Nov 2, 2021, at 5:29 PM, Alan Shore via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Thanks Jon
That was started by me
I don't know why my google search didn't find that

Alan Shore
Solutions Architect
IT Supply Chain Execution

[cid:image001.png@01D7D00F.2B843350]

60 Orville Drive
Bohemia, NY 11716
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
E-mail : ASHORE@xxxxxxxxxxxxxxxxxxxx

'If you're going through hell, keep going.'
Winston Churchill

From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf
Of Jon Paris
Sent: Tuesday, November 2, 2021 5:23 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Re: Converting upper case names to mixed case names

There was a lengthy topic on this subject a couple fo years back start
here: https://archive.midrange.com/midrange-l/201901/msg00376.html<
https://archive.midrange.com/midrange-l/201901/msg00376.html> <
https://archive.midrange.com/midrange-l/201901/msg00376.html<
https://archive.midrange.com/midrange-l/201901/msg00376.html>>

As you will see - you need to decide how special cases will be handled.
McDonald MacDonald, Macdonald, Oneil, O'neil, O'Neil, etc. etc. etc.


Jon Paris

On Nov 2, 2021, at 5:01 PM, Alan Shore via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx<mailto:rpg400-l@xxxxxxxxxxxxxxxxxx>> wrote:

Hi everyone
We are on V7r3
Does anyone know/have a routine to convert a persons first and last
name (BOTH in upper case) and translate them into mixed case?
Here are some examples
GAIL FAZIO-BROWN Gail Fazio-Brown
KYRESE DUBOSE Kyrese Dubose
DAVID DESEMPLE David Desemple
JOANNE TOWNE Joanne Towne
ELLEN TATE Ellen Tate
SERGIO DEL RIO Sergio Del Rio
BRENDA BOWMAN Brenda Bowman
MARY SHERTEL-LEWIS Mary Shertel-Lewis
ASHLEY BENCOMO Ashley Bencomo
KURT MUNRO Kurt Munro
JANE TUTTLE Jane Tuttle
KATHY JOINER Kathy Joiner
BRENDA BETZ Lester Betz
BARBARA H HOFFER Barbara H Hoffer
RICHARD CRAWFORD II Richard Crawford II
ELIZABETH A EDNEY-MILNER Elizabeth A Edney-Milner




Alan Shore
Solutions Architect
IT Supply Chain Execution

[cid:image003.png@01D7D00B.3D0AE1E0]

60 Orville Drive
Bohemia, NY 11716
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
E-mail : ASHORE@xxxxxxxxxxxxxxxxxxxx<mailto:
ASHORE@xxxxxxxxxxxxxxxxxxxx


'If you're going through hell, keep going.'
Winston Churchill

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx<mailto:
RPG400-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l<
https://lists.midrange.com/mailman/listinfo/rpg400-l>
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx<mailto:
RPG400-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l<
https://archive.midrange.com/rpg400-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:
support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com<https://amazon.midrange.com>

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx<mailto:
RPG400-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l<
https://lists.midrange.com/mailman/listinfo/rpg400-l>
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx<mailto:
RPG400-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l<
https://archive.midrange.com/rpg400-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:
support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com<https://amazon.midrange.com>
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com



--
Thanks and Regards,
Bruce
931-505-1915
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.