This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Users have been calling for a simple TITLE CASE / PROPER function since 2016.
And I know, there is @Bill.French’s wonderful script - Field Tweaker - that allows you to reformat a field as either UPPER, LOWER, or TITLE CASE.
However, the script doesn’t work when the field is a computed field, as it is in my case.
The fields I need text formatting control over are computed from different sources. I need versions of those fields that are UPPER CASE - which is easily achieved via the UPPER() function - but I also need TITLE CASE versions (for reasons I don’t want to bore anyone with).
Again, if there was a standard PROPER() function in Airtable, this would be a piece of cake.
I am sure I am not alone with this request.
Thanks for this function, @gxjansen! I created my own modified version of it that’s a little more flexible—the original formula wasn’t able to handle symbols like parentheses, hyphens, and quotation marks, which my new formula does. Additionally, I cut the number of REGEX_REPLACE() functions in half by using multi-option capturing groups. Now only a single REGEX_REPLACE() function is needed for each letter of the alphabet.
Example
Here’s a super contrived example:
The “trick” to “being” [healthy] (and happy!) and ‘wise’ {forever} ‘we promise’
Here’s what you would get with the old formula (i.e. many words aren’t capitalized):
The “trick” To “being” [healthy] (and Happy!) And “wise” {forever} ‘we Promise’
Here’s what you get with the new formula:
The “Trick” To “Being” [Healthy] (And Happy!) And “Wise” {Forever} ‘We Promise’
Complete function:
Copy and paste the complete function below into your formula, and replace {YOUR FIELD NAME HERE} with the correct field name.
Each regex function has the following capture group:
(^| |\(|\[|\{|-|\"|[ ^]\'| “| ‘)
This is a list of symbols, separated by the pipe symbol (|) which means “or”. You can add or remove symbols as you please, always separating them with a pipe. Here’s the list of symbols I’m currently matching on with explanations:
^ ← Line start
\( ← Parentheses
\[ ← Square Bracket
\{ ← Curly Brace
- ← Hyphen, ensures that hyphenated words are properly capitalized, e.g. Empty-Handed
\" ← Double quote
[ ^]\' ← Single quote. must be preceded by a space or at line beginning, this is to avoid matching apostrophes
“ ← Double curly quote
‘ ← Single curly quote
Important: this formula no longer converts the original text to lower case before capitalizing. I made this decision because there are many cases when doing this would result in incorrect capitalization. A couple examples:
Family names: McCabe would become Mccabe if we converted to lowercase first
Common acronyms: LED, DIY, ATM would become Led, Diy, Atm
If the input text you’re dealing with has a lot of ALL-CAPS you want to get rid of and you don’t care about incorrect capitalizations like the one above, you can put the initial lowercase transformation back in by adding LOWER() around the field name, like so:
Is there a way to adjust this for situations where there is a space in the {First Name} field? Such as if they had a first and middle name entered there, both in all caps, and I wanted to correct it?
Thank you!
