Formula Function Reference

Our Formula Function Reference

Trim - Text

(Text t)
Result Type: 
Returns t with leading and trailing white space characters removed. White space characters are space, tab, CR and LF.
Trim(" ABC ") returns "ABC"


RE: 'Trim doesn't seem to work'

Hi Luis,


If you visit the Support Portal at and open a case a support rep will be happy to take a look at your Trim formula.




Intuit QuickBase

Trim doesn't seem to work

I don't understand, what Can I possibly doing wrong?
after some data load from CSV's all the records were passed with leading spaces, so instead of altering each one of them, what I did was creating a formula text with trim([Field]), just that and nothing else. Now, when I try to use that field to concatenate some other values in another formula field, the leading text is still there!!!
What am I missing here?
If anyone can help me, I will deeply appreciate it!



Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit