ensuring a field has a certain number of characters in it.
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.