3 Replies Latest reply: May 15, 2014 10:11 AM by Grant Perkins RSS

    Concise way of filtering based on number of digits in a field

    MonUserCJ _

      Hey all,

       

      Occasionally, I find it useful to filter rows based on the number of digits in a field. A valid field value may have a couple of letters, but should be mostly numbers.

       

      Is there a function that will return this information easily? The trouble is that the first couple of characters in the field may be letters, so I don't think simply using a value function will work. I basically would like a function that returns the number of digits in a field (or the number of letters, I suppose).

       

      Does anyone know if there is a function available to do this, or another fast way to accomplish this?