About This Code
Brief Description:
Validate The Number of Digits in a Field
Contributor:
Andrew Jones
Last Modified:
17 Jun 2002
OpenNTF Disclaimer
All of the program code and information presented in the OpenNTF.org Code Bin are provided "as-is", and should be used at your own risk. OpenNTF.org make no express or implied warranty about anything in the Code Bin, and OpenNTF.org will not be responsible or liable for any damage caused by the use or misuse of anything from this site. OpenNTF.org makes no guarantees about anything. Please thoroughly test all of the knowledge and code you find here before you attempt to use them in your production environment.
Code / Description
If you have a field (in this case called partNumber) which should contain a value (such as a part number) which must be of a particular length, then use this type of formula in the validation formula to check the field to make sure the correct number of digits has been entered. failMsg ="Part number must be 6 characters in length"; @If (@Length (partNumber) = 6; @Success; @Failure (failMsg) If you want to add the condition that the first digit does not equal a particular value, for example X, then modify the formula to read:
msgNotSix := "Part number must be 6 characters in length"; msgX := "Part number must not begin with an X"; @If (@Length(PartNumber) != 6; @Failure(msgNotSix); @Begins(PartNumber; "X"); @Failure(msgTwo); @Success
Usage / Example