Criteria for Customized Expression Parent topic

Criteria Options for Customized Expressions

Criteria
Rule
Example
None
None
All - Names from US Census Bureau
  • Expression: [^\w]([A-Z][a-z]{1,12}(\s?,\s?|[\s]|\s([A-Z])\.\s)[A-Z][a-z]{1,12})[^\w]
Specific characters
An expression must include the characters you have specified.
In addition, the number of characters in the expression must be within the minimum and maximum limits.
US - ABA Routing Number
  • Expression: [^\d]([0123678]\d{8})[^\d]
  • Characters: 0123456789
  • Minimum characters: 9 (from 4 to 90)
  • Maximum characters: 9 (from 4 to 90)
Note
Note
Maximum characters must be larger than or equal to minimum characters.
Suffix
Suffix refers to the last segment of an expression. A suffix must include the characters you have specified and contain a certain number of characters.
In addition, the number of characters in the expression must be within the minimum and maximum limits.
All - Home Address
  • Expression: \D(\d+\s[a-z.]+\s([a-z]+\s){0,2} (lane|ln|street|st|avenue|ave| road|rd|place|pl|drive|dr|circle| cr|court|ct|boulevard|blvd)\.? [0-9a-z,#\s\.]{0,30}[\s|,][a-z]{2}\ s\d{5}(-\d{4})?)[^\d-]
  • Suffix characters: 0123456789-
  • Number of characters: 5 (from 3 to 90)
  • Minimum characters in the expression: 25 (from 4 to 90)
  • Maximum characters in the expression: 80 (from 4 to 90)
Note
Note
The number of characters in the expression must be within the minimum and maximum limits.
Single- character separator
An expression must have two segments separated by a character. The character must be 1 byte in length.
In addition, the number of characters left of the separator must be within the minimum and maximum limits. The number of characters right of the separator must not exceed the maximum limit.
All - Email Address
  • Expression: [^\w.]([\w\.]{1,20}@[a-z0-9]{2,20}[\.][a-z]{2,5}[a-z\.]{0,10})[^\w.]
  • Separator: @
  • Minimum characters to the left: 3 (from 3 to 90)
  • Maximum characters to the left: 15 (from 4 to 90)
  • Maximum characters to the right: 30 (from 4 to 90)
Note
Note
Maximum characters to the left must be larger than minimum characters to the left.
Maximum characters to the right must be larger than maximum characters to the left.