AnsweredAssumed Answered

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

Question asked by brucewashington on Mar 10, 2010
Latest reply on Mar 10, 2010 by mrvodka

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.

Outcomes