D*B our data base is mixed case for names and addresses.
If you want I can provide you with my RPG program that I use to convert strings.
It's not perfect but it has been tested on a few million names and addresses.
This is from the documentation in the program of what it can do.
*| This program can convert letters with accents on them such as ÁÉÍÑÊÚÜ |
*| It will keep words like and, of, and for in lower case |
*| Suffixes and acronyms will be in upper case like DDS, NW, III, or PhD |
*| Tricky names like duBois, DeWolfe, LaFevre, MaryAnn and d'Arcy |
*| It can identify a change in words by characters &/,- |
Spencer Carter
Systems i Programming
carter.spencer@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of D*B
Sent: Thursday, January 24, 2019 12:00 PM
To: Midrange Systems Technical Discussion
Subject: RE: [EXTERNAL] Need help to convert a name in upper case, to mixed case
<Alan>
Hi Jim
I was the originator of this e-mail thread
I was asked to push this project to one side and work on a higher priority -
which is still ongoing
</Alan>
the original process is Java?
=> this will run on AS/400 (and all compatible systems coming later)!!! Why
the hell not letting it run on the local machine???
Using a prestarted JVM (AppServer4RPG is your friend), it will run as fast
as RPG and outperform Ruby, Python, Perl - and last not least it's the
original stuff!!!
D*B
midrange.com
