| Subject | Re: Change Upper Case |
| From | Ken Mayer <dbase@nospam.goldenstag.net> |
| Date | Fri, 30 Apr 2021 21:09:40 -0700 |
| Newsgroups | dbase.getting-started |
On 4/30/2021 5:38 PM, roy price wrote: > I am using the gridcolumnindexchange.cc on my form, which seems to work well. > However the field containing text descriptions sorts words starting with upper case letter as different to those starting with a lower case letter. > The first words all start with an upper case letter, but subsequent words in the field may have either. (poor input standard) > Is there any program that would go through the records and change all words to always start with an upper case letter. > I hope to avoid the laborious editing that would make for consistency. > (obviously I would prefer not to try to modify the gridcolumnindexchange.cc program to use the UPPER() function in the index.) But that may be the way to go. lower() or string.toLowerCase() Works great ... or the other way, upper() or string.toUpperCase() However, you *do* need to alter the indexes to take advantage of that. Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm | |