Common Regular Expression Patterns

Integer "^[0-9]";

VarCharSmall "^([a-zA-Z0-9\s]{0,50})$";

VarCharBig "^([a-zA-Z0-9\s]{0,255})$";

Date(MM/DD/YYYY) "^((0[1-9])(1[0-2]))\/((0[1-9])(1\d)(2\d)(3[0-1]))\/((\d{4}))$";

Date(DD/MM/YYYY) "^(((0[1-9])(1\d)(2\d)(3[0-1])))\/(0[1-9])(1[0-2]))\/((\d{4}))$";

PasswordChar "^([a-zA-Z0-9@*#]{8,15})$";

EmailAddress "^([a-zA-Z0-9_\-])([a-zA-Z0-9_\-\.]*)@(\[((25[0-5]2[0-4][0-9]1[0-9][0-9][1-9][0-9][0-9])\.){3}((([a-zA-Z0-9\-]+)\.)+))([a-zA-Z]{2,}(25[0-5]2[0-4][0-9]1[0-9][0-9][1-9][0-9][0-9])\])$";

PhoneNumber(US) "^1?\s*-?\s*(\d{3}\(\s*\d{3}\s*\))\s*-?\s*\d{3}\s*-?\s*\d{4}$";

PhoneNumber(International) "^\d(\d-){7,20}";