Discussions

Expand all | Collapse all

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

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

    Posted 11-12-2018 22:31
    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?


  • 2.  RE: Count the number of characters in a field (text AND numeric)

    Posted 11-12-2018 22:32
    Basically, if less than 5 characters "Error".


  • 3.  RE: Count the number of characters in a field (text AND numeric)

    Posted 11-12-2018 22:59
    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]))


  • 4.  RE: Count the number of characters in a field (text AND numeric)

    Posted 11-12-2018 23:16
    YES!  IT WORKS!

    Thank you!!!