3 Replies Latest reply on Mar 10, 2010 1:33 PM by mrvodka

    ensuring a field has a certain number of characters in it.

    brucewashington

      Title

      ensuring a field has a certain number of characters in it.

      Post

      I am making a field for a ten digit number - a social security number.  It is one filled in by the people and MUST contain ten digits.

       

      I have the filter to remove characters but don't know what to add to ensure that the field has ten numbers.  Is there something I can add to this calculation

       

      Let(SSN = Filter(SSN;"0123456789");"" & Left(SSN;3) & "-" & Middle(SSN;4;2) & "-" & Middle(SSN;7;4))

       

      I would like a statement to pop up and say, you have to have 10 numbers in this field.

       

      Thanks for any help.