Capitalization Conversion (AREV Specific)
At 04 JAN 2002 07:56:11PM Matt Sorrell wrote:
Is there a function or conversion in ARev 3.02 that will allow me to do the following:
Input=SORRELL,MATTHEW B
Desired Output=Sorrell,Matthew B
Basically, I need to take a name string that is in all caps and convert it to "normal" capitalization.
I've found a subroutine in our system that I don't have the source for that checks for normal capitalization, but can't find one that will do the conversion. As near as I can tell, the system forces entry to be in normal capitalization, and then does a convert to all uppercase for use elsewhere.
I have also found a validation that uses %LC%, but it doesn't appear to work as an oconv/iconv arguement.
Any help would be appreciated.
msorrel@greyhound.com
At 04 JAN 2002 08:35PM Mike Ruane wrote:
Matt-
Use NameCap
eg:
Declare Subroutine Namecap
@ans=MATT SORRELL'
Namecap()
@ans would now be Matt Sorrell
Hope it helps-
MIke
At 07 JAN 2002 07:02AM Cameron Christie wrote:
NameCap is as good a place to start as any, but it's a good idea to code this as the start of a function and then code all the exception logic afterwards yourself as it doesn't deal with some sorts of name "out of the box".
Us Gaelic types seem to be particularly discriminated against: e.g. O'CONNER comes out as O'conner, and MCKAY comes out as Mckay, not McKay. Watch out too for hyphenated names!
FWIW,
Cameron
At 07 JAN 2002 09:13AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Dood - how's it cope with say Me'Shell N'Degé O'Cello?
Or the Ma'cc La'dds .
World Leaders in all things RevSoft
JavaScript now disabled - so no menu
At 07 JAN 2002 12:59PM Cameron Christie wrote:
Badly!
No Sheep 'til Buxton!
At 07 JAN 2002 01:08PM Matt Sorrell wrote:
Mike,
Thanks for the info. I sure couldn't find that function anywhere in the docs when I was looking. Sounds like exactly what I'm looking for.
As for Cameron's concerns with Gaelic names, et. al., I'm not that concerned about that. The routine that I need this for handles only a limited number of records, and the users have already been told that they might have to update the names manually, so they'll be happy for even 80% automation of this task.
Again, thanks for the help!!
msorrel@greyhound.com
At 07 JAN 2002 01:12PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Ayayay love Macclesfield… it's a great place for a walk…
Any chance of seeing you in Vegas in August?
World Leaders in all things RevSoft
At 07 JAN 2002 02:48PM Cameron Christie wrote:
"He'll tell you lies, he'll eat your pies…"
Hopes are VERY high for a Vegas visit (at which I shall NOT be drinking Coors!
You've more chance of seeing me there than in London this year.
At 07 JAN 2002 03:09PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Ahhh, the lovely Coors…
Cool - hoping to be mob-handed this year, we'll see.
"I took her outside, we started chattin'. I said 'tell the lads that….'" - halycon days… got the out-takes on the desk in front of me as we type. (That and Eastsidaz, Ice Cube, Dre and George Formby).
World Leaders in all things RevSoft