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

Question

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?

jrossausiscom · Answer

Basically, if less than 5 characters "Error".

quickbasecoachd · Answer

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]))

jrossausiscom · Answer

YES!&nbsp; IT WORKS!Thank you!!!

Forum Discussion

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

Related Content

Roundup whole number

how to count the number of specific characters

Formula-Numeric Field Returning Null Instead of 0

Calculating number of days between two date fields

IF statement changing numeric to text