Matches Pattern¶
| Rule | MatchesPattern |
|---|---|
| Default Rule Name | |
| Description | Checks whether a field value matches a regular Java expression. Values that match the selected pattern are written to the Pass Target. Values that do not match the selected pattern are written to the Fail Target. |
| Rule Parameters | Regex Pattern: Select from the following list: • 12 Hour Time Format • 24 Hour Time Format • AlphaNumeric Strings • AnyString • ASCII characters only • Canada Postal Code • Canada Social Insurance Number • Credit Card Number • Days of Week • Digits Only • Email Address • Germany Postal Code • Germany Phone Number • Germany Sozialversicherungsnummer • India Postal Code • India Phone Number • India Aadhaar Number • Ip4 Address • ISBN_10 Number • Mr Or Mrs • Printable Characters • Single Alphabetic Character • UK Postal Code • UK Phone Number • UK National Insurance Number • US Currency • US Phone Number • US Social Security Number • US Standard Date Format • US Zipcode • Vehicle Identification Number • YYMMDD Date FormatFor a description of Regex Pattern options, see Remarks. |
| Supported Data Types | String |
| Remarks | Listed below are the regular Java expressions for Regex Pattern options: • 12 Hour Time Format - ^ (1[0-2]|0?[1-9]):[0-5][0-9] *(a|p|A|P)(m|M) *\(<br>• 24 Hour Time Format - (([0-1][0-9])\|([2][0-3])):([0-5][0-9]):([0-5][0-9])<br>• AlphaNumeric Strings - ^[a-zA-Z0-9]+\) • AnyString - . • ASCII characters only - ^([a-zA-Z0-9!\"#$%&',/:;<=>@_ \|~ \\(\\)\\\\+\\-\\.\\?\\[\\]\\\\\\^\\{\\}])$<br>• Canada Postal Code - ^([A-Za-z]\\d[A-Za-z][\\s-]?\\d[A-Za-z]\\d)<br>• Canada Social Insurance Number - ^(\\d{3}-\\d{3}-\\d{3})\|(\\d{9})$<br>• Credit Card Number - ^[1-9][0-9]{3}(\\s?\|-?)[0-9]{4}\\1[0-9]{4}\\1[0-9]{4}$<br>• Days of Week - ^(?i)(Sun\|Mon\|(T(ues\|hurs))\|Fri)(day\|\\.)?$\|Wed(\\.\|nesday)?$\|Sat(\\.\|urday)?$\|T((ue?)\|(hu?r?))\\.?$<br>• Digits Only - ^\\d+$"<br>• Email Address - ^(([A-Za-z0-9]+_+)\|([A-Za-z0-9]+\\-+)\|([A-Za-z0-9]+\\.+)\|([A-Za-z0-9]+\\++))[A-Za-z0-9]+@((\\w+\\-+)\|(\\w+\\.))\\w{1,63}\\.[a-zA-Z]{2,63}$<br>• Germany Postal Code - ^[0-9]{5}$<br>• Germany Phone Number - ^((((00\|\\+)?49[- .]?\|0)(((\\d{2,3})([- .]?\\d{4}){2})\|((\\d{4})([- .]?\\d{3})([- .]?\\d{4}))\|((3\\d{4})([- .]?\\d{2})([- .]?\\d{4}))\|(((15\\d{2})\|(16\\d)\|(17\\d))([- .]?\\d{3})([- .]?\\d{4}))))\|(((00\|\\+)?49[- .]?\\(\|\\(0)(((\\d{2,3}\\))([- .]?\\d{4}){2})\|((\\d{4}\\))([- .]?\\d{3})([- .]?\\d{4}))\|((3\\d{4}\\))([- .]?\\d{2})([- .]?\\d{4}))\|(((15\\d{2})\|(16\\d)\|(17\\d))([- .]?\\d{3})([- .]?\\d{4})))))$<br>• Germany Sozialversicherungsnummer - ^[0-9]{2}(\\s?\|-?)[0-9]{2}[0,1][0-9][0-9]{2}\\1[A-Z]\\1[0-9]{2}[0-9]$<br>• India Postal Code - ^[0-9]{6}$<br>• India Phone Number - ^(((((00\|\\+)?91[- .]?)\|0)(((\\d{2})([- .]?\\d{8}))\|((\\d{3})([- .]?\\d{7}))\|((\\d{4})([- .]?\\d{6}))))\|((((00\|\\+)?91[- .]?\\()\|\\(0)(((\\d{2}\\))([- .]?\\d{8}))\|((\\d{3}\\))([- .]?\\d{7}))\|((\\d{4}\\))([- .]?\\d{6}))))\|(((00\|\\+)?91[- .])?(\\d{4}[- .]?){2}(\\d{2})))$<br>• India Aadhaar Number - ^[2-9]{1}[0-9]{3}\\s*-?[0-9]{4}\\s*-?[0-9]{4}$<br>• Ip4 Address - ^((25[0-5]\|(2[0-4]\|1\\d\|[1-9]\|)\\d)\\.?\\b){4}$<br>• ISBN_10 Number - ^(?:ISBN(?:-1[03])?:? )?(?=[0-9X]{10}$\|(?=(?:[0-9]+[- ]){3})[- 0-9X]{13}$\|97[89][0-9]{10}$\|(?=(?:[0-9]+[-\n]){4})[- 0-9]{17}$)(?:97[89][- ]?)?[0-9]{1,5}[- ]?[0-9]+[-\n]?[0-9]+[- ]?[0-9X]$<br>• Mr or Mrs - ^Mr$\|^Mrs$<br>• Printable Characters - ^([a-zA-Z0-9\\s!@#$%^&*()_=+;:'\"\|~<>?/{}-]+)$ |
| • Single Alphabetic Character - ^[a-zA-Z]\(<br>• UK Postal Code - ^([A-Z]{1,2}[0-9]{1,2}\|[A-Z]{3}\|[A-Z]{1,2}[0-9][A-Z])( \|-)[0-9][A-Z]{2}<br>• UK Phone Number - ^(((((00\|\\+)?44[- .]?)\|0)(((2\\d)([- .]?\\d{4}){2})\|(((11\\d)\|(1\\d1))([- .]?\\d{3})([- .]?\\d{4}))\|((1\\d{3})([- .]?\\d{2})([- .]?\\d{3,4}))\|((\\d{5})([- .]?\\d{2})([- .]?\\d{3}))\|((\\d{5})([- .]?\\d{4,5}))))\|((((00\|\\+)?44[- .]?\\()\|\\(0)(((2\\d\\))([- .]?\\d{4}){2})\|(((11\\d\\))\|(1\\d1\\)))([- .]?\\d{3})([- .]?\\d{4}))\|((1\\d{3}\\))([- .]?\\d{2})([- .]?\\d{3,4}))\|((\\d{5}\\))([- .]?\\d{2})([- .]?\\d{3}))\|((\\d{5}\\))([- .]?\\d{4,5})))))\) • UK National Insurance Number - ^([ACEHJLMOPRSW-Yacehjlmoprsw-y][A-CEGHJ-NPRSTW-Za-ceghj-nprstw-z]|[Bb][A-CEHJ-NPRSTW-Za-cehj-nprstw-z]|[Gg][ACEGHJ-NPRSTW-Zaceghj-nprstw-z]|[Kk][A-CEGHJ-MPRSTW-Za-ceghj-mprstw-z]|[Nn][A-CEGHJLMNPRSW-Za-ceghjlmnprsw-z]|[Tt][A-CEGHJ-MPRSTW-Za-ceghj-mprstw-z]|[Zz][A-CEGHJ-NPRSTW-Ya-ceghj-nprstw-y])(\s?|-?)[0-9]{2}\2[0-9]{2}\2[0-9]{2}\2[A-Da-d ]?\(<br>• US Currency - ^\\\)\d*(.\d{1,2})?\(<br>• US Phone Number - ^((\\+?1[- .]?)?((\\([2-9]\\d{2}\\))\|([2-9]\\d{2}))[- .]??[2-9]\\d{2}[- .]?\\d{4})\) • US Social Security Number - ^[0-9]{3}-?[0-9]{2}-?[0-9]{4}\(<br>• US Standard Date Format - ^([0]\\d\|[1][0-2])\\/([0-2]\\d\|[3][0-1])\\/([2][01]\|[1][6-9])\\d{2}(\\s([0-1]\\d\|[2][0-3])(\\:[0-5]\\d){1,2})?\) • US Zipcode - ^[0-9]{5}(-[0-9]{4})?\(<br>• Vehicle Identification Number - ^(([a-h,A-H,j-n,J-N,p-z,P-Z,0-9]{9})([a-h,A-H,j-n,J-N,p,P,r-t,R-T,v-z,V-Z,0-9])([a-h,A-H,j-n,J-N,p-z,P-Z,0-9])(\\d{6}))\) • YYMMDD Date Format - ^((\d{2}((0[13578]|1[02])(0[1-9]|[12]\d|3[01])|(0[13456789]|1[012])(0[1-9]|[12]\d|30)|02(0[1-9]|1\d|2[0-8])))|([02468][048]|[13579][26])0229)$ |