Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- Tom Rettigs Library - capfirst(<expc>) http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 CAPFIRST(<expC>)
 Capitalizes the first letter of each word, lowercases the rest.
 Returns lowercase <expC> with first alpha character of each word uppercase.

 Useful where database files contain entries that are all uppercase,
 all lowercase, or randomly mixed.

 A new word is considered to begin with the first character
 immediately following a space or hyphen.

 USE File   && close when no longer needed
 * Display from a database file with bad cases
 ? CAPFIRST(TRIM(Firstname)), CAPFIRST(Lastname)
 ? CAPFIRST(Address)
 * Fix a database file with bad case entries
 REPLACE ALL Lastname WITH CAPFIRST(Lastname),;
            Firstname WITH CAPFIRST(Firstname),;
              Address WITH CAPFIRST(Address)


             Placed in the Public Domain by Tom Rettig Assoc.

See Also: EXPAND()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson