<Slightly OT> Case conversion in Star Office

[Bill Campbell]

On Sat, Feb 08, 2003 at 12:12:39PM -0500, Bouncer wrote:
>I have some rather large spreedsheets that are all in upper case letters, but 
>need to convert them to proper name format, i.e. FRED ROGERS becomes Fred 
>Rogers.

Depending on the complexity of the sheets, I would probably export the
sheet to a tab delimited file, do the edits with a perl script, then import
the new tab delimited file.

The NeXS spreadsheet would permit you to do this directly with a perl
script, or you could do it via a tcp socket.

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
UUCP:               camco!bill  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676
URL: http://www.celestial.com/

A fake fortuneteller can be tolerated.  But an authentic soothsayer should
be shot on sight.  Cassandra did not get half the kicking around she deserved.
		-- R.A. Heinlein