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

Just a thought ...

Your original post mentioned that you were calling an external routine (Java?) to do the conversion.

Why not use PHP or node or Python on your own box and use one of the many available name case routines as a web service? I have a PHP routine that doesn't quite do what you want but it is close and could no doubt be fairly easily modified. For the sample list you gave (and a couple of extras) it produces this:

GAIL FAZIO-BROWN is converted to Gail Fazio-Brown
KYRESE DUBOSE is converted to Kyrese Dubose
DAVID DESEMPLE is converted to David Desemple
JOANNE TOWNE is converted to Joanne Towne
ELLEN TATE is converted to Ellen Tate
SERGIO DEL RIO is converted to Sergio del Rio
BRENDA BOWMAN is converted to Brenda Bowman
MARY SHERTEL-LEWIS is converted to Mary Shertel-Lewis
ASHLEY BENCOMO is converted to Ashley Bencomo
KURT MUNRO is converted to Kurt Munro
JANE TUTTLE is converted to Jane Tuttle
KATHY JOINER is converted to Kathy Joiner
BRENDA BETZ is converted to Brenda Betz
BARBARA H HOFFER is converted to Barbara H Hoffer
RICHARD CRAWFORD II is converted to Richard Crawford Ii
ELIZABETH A EDNEY-MILNER is converted to Elizabeth A Edney-Milner
John H MCDONALD is converted to John H McDonald
JACK MACDONALD is converted to Jack MacDonald
JACOB MCCLOUD is converted to Jacob McCloud

The Richard Crawford II one is wrong but I'm not sure why and haven't the time to debug. Sergio del Rio is different from what you had but I think this version (del in lower) is probably correct.

I was thinking at one time of converting it all to RPG but it makes extensive use of regex_replace and it would take me too long to wrestle that into RPG.

Just a thought.


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