Default data patterns

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • Review the default data pattern regular expressions included in Data Discovery. These default data patterns can be used to filter table entries for further classification.

    The following are available default patterns for Data Discovery.

    Name Description Regular Expression Keywords Examples
    Age A person's age between 0-99 \b([0-9]|[1-9][0-9]|1[012][0-9])\b age
    Matching
    24
    Non matching
    • 103
    • -2
    Date of birth Date of birth using the DD/MM/YYYY format \b[0-3]?[0-9]/[0-3]?[0-9]/(?:[0-9]{2})?[0-9]{2}\b dob, birthday, date of birth
    Matching
    • 06/18/2012
    • 1/1/19
    Email Standard email address \b[\w!#$%&'*+/=?`{|}~^-]+(?:\.[\w!#$%&'*+/=?`{|}~^-]+)*@(?:[a-zA-Z0-9-]+\.)+[a-zA-Z]{2,6}\b
    Matching
    • johndoe@emailserver.com
    • historyprofessor@collegehigh.edu
    Non matching
    • notanemail.com
    • bademail@.org
    Vehicle identification number A vehicle identification number (VIN) \b[A-HJ-NPR-Z0-9]{17}\b
    Matching
    AHUYA31581L000000
    IP Address Standard IP address
    4 digit IP
    \b(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\b
    6 digit IP
    \b(((?:[0-9A-Fa-f]{1,4}(?::[0-9A-Fa-f]{1,4})*)?)::((?:[0-9A-Fa-f]{1,4}(?::[0-9A-Fa-f]{1,4})*)?))|((?:[0-9a-fA-F]{1,4}:){7}[0-9a-fA-F]{1,4})\b
    Matching 4 digit IP
    102.28.46.103
    Matching 6 digit IP
    914b:d45a:61ea:6346:59bc:3085:ee8b:0ccb
    Credit Card- Visa Visa credit card number \b4[0-9]{12}(?:[0-9]{3})?\b
    Matching
    4444434342424242
    Credit Card- American Express American Express credit card number \b3[47][0-9]{13}\b
    Matching
    378225246366005
    Credit Card- Mastercard Mastercard credit card number \b(?:5[1-5][0-9]{2}|222[1-9]|22[3-9][0-9]|2[3-6][0-9]{2}|27[01][0-9]|2720)[0-9]{12}\b
    Matching
    5555444455554444
    Credit Card- Diners Club Diners Club credit card number \b3(?:0[0-5]|[68][0-9])[0-9]{11}\b
    Matching
    3056930009020004
    Credit Card- Discover Discovery credit card number \b6(?:011|5[0-9]{2})[0-9]{12}\b
    Matching
    6011025690875424
    Credit Card- CCV Credit card security number \b[0-9]{3,4}\b cvv,verification code,security code
    Matching
    124
    Credit Card- Expire Date Credit card expiration in MM/YYYY format \b(([1-9])|(0[1-9]|1[0-2]))\/?([0-9]{4}|[0-9]{2})\b expire,exp
    Matching
    • 02/2027
    • 04/23
    Non matching
    03/9
    USA- Social security number USA citizen social security number \b(?!666|000|9\d{2})\d{3}-(?!00)\d{2}-(?!0{4})\d{4}\b
    Matching
    001-22-111
    USA- Phone Number USA phone number
    Warning:
    Does not use the USA calling code.
    		 \b\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})\b
    Matching
    2065550199
    Non matching
    1 555 238 0199
    USA- Passport Number 9 digit USA passport number \b[a-zA-Z0-9]\\d{8}\b
    Matching
    770022122
    USA- Taxpayer ID USA taxpayer ID number \b(9\d{2})([ \-]?)([7]\d|8[0-8])([ \-]?)(\d{4})\b
    Matching
    927 70 5828
    USA- California State Driver License number State of California, USA driver license number \b[a-zA-Z]\d{7}\b
    Matching
    A0002144
    USA - Bank Routing number US Bank Routing (ABA) number \b((0[0-9])|(1[0-2])|(2[1-9])|(3[0-2])|(6[1-9])|(7[0-2])|80)([0-9]{7})\b
    Matching
    125210305