[SOLVED] Formatting

What is the best way to format some CB fields (for example first and last name) to capitalize the first letter of each word and change the remaining letters to lowercase if necessary. So when a user registers like: cb saves it as follows to the database:
And where should this be done? Is it possible via CB fields or should an auto action be created?

Thanks,

Sima

Best way is to leave their name alone. You can't assume how their name is formatted. My last name is a capital first letter then a capital 3rd letter. I can't explain how frustrating it is when systems mess it up. At any rate you could use CB Auto Actions and enable format functions under Parameters to allow them to work on the action. You can then reformat the name as needed. Example usage as follows.


The first format function lowercases the entire name. The second uppercases the first letter of each word. Another option is to use CSS and try the following, but it'll only work for the first letter of the name. To work around that you could change the name fields layout to put together first, middle, and lastname substitutions with spans surrounding them then style those spans.

Yes you are right, it is very frustrating when systems mess that up. I forgot about the various complexities of how names are formed. So I definitely agree that it is better to leave it alone. Thanks for the wise feedback.