Views:

Cleaning Samples

Removes all digits from a string

 

RegexReplace('stringinput', «\d», '')

 

 

Removes all characters from a string to only leave digits

 

RegexReplace('stringinput', «\D», '')

 

 

Removes duplicate white space (tabs, newlines, spaces, etc,) from a string

 

RegexReplace('stringinput', «\s+», ' ')

 

 

Removes all ascii characters from a string

 

RegexReplace('stringinput', «[^\u0000-\u007F]», '')

 

 

Removes all ascii characters and ascii control characters from a string

 

RegexReplace('stringinput', «[^\w\.@-]», '')

 

 

Formats a US telephone number

 

RegexReplace('US telephone number', «(\d{3})(\d{3})(\d{4})», «($1) $2-$3»)

 

 

Formats a US telephone number with extensions

 

RegexReplace('US telephone number', «^\D*(\d)\D*(\d)\D*(\d)\D*(\d)\D*(\d)\D*(\d)\D*(\d)\D*(\d)\D*(\d)\D*(\d)\D*(\d{2,})$», «+1 ($1$2$3) $4$5$6-$7$8$9$10 Ext $11»)

 

 

 

 

Validation Samples 

Validates an email address

 

 RegexIsMatch('Email address', «^[\w-]+(\.[\w-]+)*@([a-z0-9-]+(\.[a-z0-9-]+)*?\.[a-z]{2,6}|(\d{1,3}\.){3}\d{1,3})(:\d{4})?$»)

 


 
Validates an Uri

 

 RegexIsMatch('Uri', «(http|ftp|https):\/\/[\w\-_]+(\.[\w\-_]+)+([\w\-\.,@?^=%&:/~\+#]*[\w\-\@?^=%&/~\+#])?»)

 


 
Validates any whole or decimal number

 

 RegexIsMatch('Any whole or decimal number', «^([0-9]*|\d*\.\d{1}?\d*)$»)

 


 
Validates US Currency

 

 RegexIsMatch('US Currency', «^\$(\d{1,3}(\,\d{3})*|(\d+))(\.\d{2})?$»)

 


 
Validates one numeric digit

 

 RegexIsMatch('One numeric digit', «^\d$»)

 

 
Validates a percentage to 2 decimal places

 

 RegexIsMatch('A percentage to 2 decimal places ', «^( 100(?:\.0{1,2})? | 0*?\.\d{1,2} | \d{1,2}(?:\.\d{1,2})? )% $»)

 


 
Validates a password must be at least 8 characters, no more than 15 characters, and must include at least one upper case letter, one lower case letter, and one numeric digit

 

RegexIsMatch('A password must be at least 8 characters, no more than 15 characters, and must include at least one upper case letter, one lower case letter, and one numeric digit', «^(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).{8,15}$»)

 


 
Validates a UK vehicle registration

 

 RegexIsMatch('A UK vehicle registration', «^([A-Z]{3}\s?(\d{3}|\d{2}|d{1})\s?[A-Z])|([A-Z]\s?(\d{3}|\d{2}|\d{1})\s?[A-Z]{3})|(([A-HK-PRSVWY][A-HJ-PR-Y])\s?([0][2-9]|[1-9][0-9])\s?[A-HJ-PR-Z]{3})$»)

 


 
Validates alpha numeric values

 

 RegexIsMatch('Alpha numberic values', «^[a-zA-Z0-9]+$»)

 


 
Validates a UK National Insurance Number

 

 RegexIsMatch('A UK National Insurance Number', «^[A-CEGHJ-PR-TW-Z]{1}[A-CEGHJ-NPR-TW-Z]{1}[0-9]{6}[A-DFM]{0,1}$»)

 


 
Validates credit card numbers

 

 RegexIsMatch('Credit card numbers', «^((4\d{3})|(5[1-5]\d{2})|(6011))-?\d{4}-?\d{4}-?\d{4}|3[4,7]\d{13}$»)

 


 
Validates US telephone numbers

 

 RegexIsMatch('US telephone numbers', «^[01]?[- .]?\(?[2-9]\d{2}\)?[- .]?\d{3}[- .]?\d{4}$»)

 


 
Validates US Zip Codes

 

 RegexIsMatch('US Zip Codes', «(^(?!0{5})(\d{5})(?!-?0{4})(-?\d{4})?$)»)

 


 
Validates German Post Codes

 

 RegexIsMatch('German Post Codes', «\b((?:0[1-46-9]\d{3})|(?:[1-357-9]\d{4})|(?:[4][0-24-9]\d{3})|(?:[6][013-9]\d{3}))\b»)

 

 
Validates UK Post Codes

 

 RegexIsMatch('UK Post Codes', «^([A-PR-UWYZ0-9][A-HK-Y0-9][AEHMNPRTVXY0-9]?[ABEHMNPRVWXY0-9]? {1,2}[0-9][ABD-HJLN-UW-Z]{2}|GIR 0AA)$»)

 


 
Validates UK Telephone Number

 

 RegexIsMatch('UK Telephone Number', «(\s*\(?0\d{4}\)?(\s*|-)\d{3}(\s*|-)\d{3}\s*)|(\s*\(?0\d{3}\)?(\s*|-)\d{3}(\s*|-)\d{4}\s*)|(\s*(7|8)(\d{7}|\d{3}(\-|\s{1})\d{4})\s*)»)

 


 
Validates US Telephone Number

 

 RegexIsMatch('US Telephone Number', «^([0-9]( |-)?)?(\(?[0-9]{3}\)?|[0-9]{3})( |-)?([0-9]{3}( |-)?[0-9]{4}|[a-zA-Z0-9]{7})$»)

 


 
Validates date of birth (MM/DD/YYYY)

 

 RegexIsMatch('Date of birth (MM/DD/YYYY)', «^((0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01])[- /.](19|20)?[0-9]{2})*$»)

 


 
Validates for digits only

 

 RegexIsMatch('Digits only', «^[0-9]*$»)

 


 
Validates US social security numbers

 

 RegexIsMatch('US social security number', «/^([0-9]{3}[-]*[0-9]{2}[-]*[0-9]{4})*$/»)

 

 

Did you know?

North52 helps Government (federal and state) departments with complex rules in their Dynamics 365 systems

Public sector organizations frequently deal with large user bases and complex rules and routings. The North52 Decision Suite helps government orgnizations with Dynamics 365 manage processes like:

  • Case Management - task checklists, routing, prioritization and approval
  • Eligibility checks for applications/enrollment
  • Licensing administration

Learn more about the North52 Decision Suite