Gary Stainburn said: > 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.
s/(\w+)/\u\L$1/g or s/(\w+)/ucfirst lc $1/eg -- Paul Johnson - [EMAIL PROTECTED] http://www.pjcj.net -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]