Text case converter is a handy web application that allows you to change text case of any text easily to upper case, lower case, title case or sentence case. Simply paste the text you want to convert into the text area below, click on one of the buttons and let the tool to do the work for you.
There are exceptions to this (like names, etc), but they can be handled on a case basis. It capitalizes the first letter of each word in a string.
Example: Tags: AAG, AFHood Analytics Group, capitalize, character, character type, character variable, function, functions, lowcase, lower case, lowercase, names, propcase, proper case, SAS, SAS Code, string functions, upcase, upper case, uppercase Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site.
This function splits up words delimited by a space, and makes only the first letter of each word capitalized.
You can easily modify it so it's only the very first word of the string.
Then the content of "change case" in Cell A1 is copied and changed to "CHANGE CASE" in Cell C1.
See screen shot: Select the Cell C1, and you can copy the formula to other cells by dragging at bottom-right corner and dropping down to other cells.
In order to convert all characters in a sting to lowercase, use the LOWCASE function.
Example: We can’t stress the importance of keeping this functionality in mind.
Many a SAS script has gone awry because a developer didn’t take character case into account when using conditional or search statements.
TIP: A solid programming practice is to convert everything to lowercase before storing it.
On Ubuntu Dapper, I had to copy entries over from /usr/share/i18n/SUPPORTED to /var/lib/locales/supported.d/local, then do the dpkg-reconfigure. That said, there are special cases where you want to do the conversion manually.