Skip to main content
Question

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

  • November 13, 2018
  • 0 replies
  • 183 views
Forum|alt.badge.img+6
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?
    This topic has been closed for replies.

    Forum|alt.badge.img+6
    • jrossausiscom
    • Author
    • Registered
    • November 13, 2018
    Basically, if less than 5 characters "Error".
    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]))
    Forum|alt.badge.img+6
    • jrossausiscom
    • Author
    • Registered
    • November 13, 2018
    YES!  IT WORKS!

    Thank you!!!
    Terms & ConditionsAccessibility statement