Count the number of characters in a field (text AND numeric)

  • 1
  • 1
  • Question
  • Updated 1 month ago
  • Answered
I need to create a calculated column that will only show me records where, in this case, the ZIP is less than 5 digits.  Length returns the error "expecting text".  Is there not a way to count numeric characters?
Photo of John Ross

John Ross

  • 528 Points 500 badge 2x thumb

Posted 1 month ago

  • 1
  • 1
Photo of John Ross

John Ross

  • 528 Points 500 badge 2x thumb
Basically, if less than 5 characters "Error".
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
I assume that your zip field is numeric, so you need to convert it to text before you can count characters.


Length(ToText([my numeric zip field goes here]))
Photo of John Ross

John Ross

  • 528 Points 500 badge 2x thumb
YES!  IT WORKS!

Thank you!!!