Skip to content
Magenaut

Magenaut

  • Home
  • Topics
    • Notes
    • Tutorial
    • Bug fixing
    • Extension
    • Server
  • Q&A
  • Privacy Policy
  • About

title-case

Is there a simple way to convert MySQL data into Title Case?

November 22, 2022 by Magenaut

I have a MySQL table where all the data in one column was entered in UPPERCASE, but I need to convert in to Title Case, with recognition of “small words” akin to the Daring Fireball Title Case script.

Categories MySQL, Q&A Tags mysql, phpmyadmin, title-case Leave a comment

Make all words lowercase and the first letter of each word uppercase

October 21, 2022 by Magenaut

I have a string with improper capitalization scattered like below:

Categories PHP, Q&A Tags php, string, title-case, ucfirst Leave a comment

Title case a string containing one or more last names while handling names with apostrophes

October 18, 2022 by Magenaut

I want to standardize a user-supplied string. I’d like the first letter to be capitalized for the name and if they have entered two last names, then capitalize the first and second names. For example, if someone enters:

Categories PHP, Q&A Tags humanize, php, string, title-case, ucfirst Leave a comment

Titlecasing a string with exceptions

August 12, 2022 by Magenaut

Is there a standard way in Python to titlecase a string (i.e. words start with uppercase characters, all remaining cased characters have lowercase) but leaving articles like and, in, and of lowercased?

Categories Python, Q&A Tags python, string, title-case Leave a comment

Recent Comments

  • silverplugins217 on How to add placeholder for contact form7 for dropdown?
  • Shreyas Ikhar on How to add a custom CSS class to core blocks in Gutenberg editor?
  • Magenaut on How to call function on timer ASP.NET MVC
  • Ebaad Uddin on How to call function on timer ASP.NET MVC
  • michealSmith07 on Is there a way to dynamically refresh the less command?

Tags

.net adobe-illustrator adobe-photoshop ajax arrays asp.net asp.net-core asp.net-mvc bash c# css database django eloquent express html java javascript jquery json laravel laravel-4 laravel-5 laravel-8 linux list mongodb mongoose mysql node.js npm pandas php python python-3.x react-hooks react-native react-router reactjs redux regex sql string typescript wordpress
© 2023 Magenaut • Built with GeneratePress