Hi folks,

I've got a problem I hope you can help me with.

I've got to tidy some data, including converting case.  I need to convert

ANOTHER COMPANY NAME LTD      **

to

Another Company Name Ltd      **

while retaining spaces.

I've tried using split / join / lc / ucfirst which does most of the work but 
loses the spacings.  

I guess that there's a regex that will do this but I'm at a loss how.

-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to