I have recently been giventhe job of importing some old DOS information into
our sales database. The database is FMP. Could someone pplease tell me how
I can change multiple words in a text field from all upper case to upper
case on the first letter and lower case on all subsequesnt letters, please.
The volume of information is huge and I would love to find/build ascript to
do this.

Thanks in advance.

Bob Wilson

On 16/8/2003 1:55 AM, in article vjq0jjrhuqjkfc (AT) corp (DOT) supernews.com, "Dick
Malick" <Dick (AT) malick (DOT) com> wrote:


Try creating a calc field using the Proper(<your text field here>) function.

HTH

Andrew
--
NICHE IT PTY LTD
Sydney, Australia
+61 (0)407 482 609
http://www.nicheit.com.au

On 16/8/2003 2:07 AM, in article BB634249.36BF%andrew (AT) nicheit (DOT) com.au,
"Andrew McCallum" <andrew (AT) nicheit (DOT) com.au> wrote:

Oh... and once you are happy with the result in the calc field you can run a
replace either manually or as a script, and move the data back into the
correct field.

Andrew