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?