Formula: Trim(), Lower(), and Upper()
Category: String
Trim()
Trims extra spaces before and after text
It’s kind of like saying...
Hey Coda, I have extra spaces before and after my text. Will you get rid of them?
Lower()
Converts your text values to lower case
Or put another way...
Hey Coda, at least some of my text is upper case. Will change it to all lower case?
Upper()
Converts your text values to lower case
Or put another way...
Hey Coda, at least some of my text is lower case. Will change it to all upper case?
All three formulas use the same, single parameter.
Text
Trim(Text)
This is the text you want to trim or convert to lower/upper case.
How Do They Work?
Trim(), Lower() , and Upper() are simple formulas to understand, so this section will be brief. But don’t skip the activities! These formulas are an absolute!
Original Sentence
Woah! Watch out for the rogue asteroid. It may take down your ship.
This sentence is characters long Trim() is simply taking the original sentence and taking the spaces off the front and back of the sentence. Notice how the character count changes when the Trim button above is pressed. Lower() is simply taking the original sentence and making every character in the sentence a lower-case letter
Trim() is simply taking the original sentence and making every space an upper-case character
This sentence is characters long
Why Are They Important?
Trim(), Lower(), and Upper() are absolute must-haves in your Coda tool-belt. Without them you’ll find bug after bug in your formulas and tables. As an exercise, look at the tables below. Why do you think the Total Votes column below in yellow only has a total of 4 votes? Click into the column to view its formula, or see it to the right.
total votes have been counted
Class choices for favorite animal
From first glance, the formula is sound! It should work. But double click into the first two dog columns (the columns in blue) and pay attention to where your cursor lands.
If you pay attention closely you will notice that the first Dog value is only three characters long, but the 2nd Dog value is actually 4 characters long and includes an extra space at the end. These spaces will actually mess up your filter formulas. This is just one way to validate your data and ensure your filters work!
But wait! Theres more - uncollapse the headers below to keep your docs running smooth, fast, and accurate. How to fix your filters: The wrong way
Filters (Filter()) are the number one culprit when it comes to a decrease in doc-performance.
Click into the wrong way column below to see how you should not write your formulas
Writing calculations or formulas inside your Filter() formulas is the wrong way - as much as you can, try to avoid it at all costs. Always compare values to values.
Now that you have learned the wrong way, go ahead and look into the right way.
How to fix your filters: The right way
Instead of using Trim() and Lower() inside of the filter formula itself, it is much faster (for your docs performance) to create secondary helper columns that trim/lower the values and then compare those columns within your filter formula
See the Animal Trimmed column below, and finally, click into the green Right Way column below to see how the formula is written.