Default regular expression data patterns

  • Release version: Australia
  • Updated March 12, 2026
  • 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.

    Data Discovery supports using a Named Entity Recognition (NER) model to discover data, such as names, organizations, nationalities, and political affiliations. Data patterns with the type Model use this feature.

    The following table details the default regular expression patterns for data discovery.

    Name Description Regular Expression Keywords Examples
    Age A person's age between 0-129 \b([0-9]|[1-9][0-9]|1[012][0-9])\b age
    Matching
    • 24
    • Age is 100
    Non matching
    • -2
    • I am 100 years old
    • Age is 130
    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
    Non matching
    August 21, 1974
    08-21-74
    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
    Non matching
    112-32-3478
    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 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
    Non matching
    28554
    Credit Card- American Express American Express credit card number \b3[47][0-9]{13}\b
    Matching
    378225246366005
    Non matching
    1199
    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
    Non matching
    1223455
    Credit Card- Diners Club Diners Club credit card number \b3(?:0[0-5]|[68][0-9])[0-9]{11}\b
    Matching
    3056930009020004
    Non matching
    7721
    Credit Card- Discover Discovery credit card number \b6(?:011|5[0-9]{2})[0-9]{12}\b
    Matching
    6011025690875424
    Non matching
    999
    Credit Card- CCV Credit card security number \b[0-9]{3,4}\b cvv,verification code,security code
    Matching
    124
    Non matching
    33441
    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
    Non matching
    3321146781
    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
    Non matching
    67431
    USA- Taxpayer ID USA taxpayer ID number \b(9\d{2})([ \-]?)([7]\d|8[0-8])([ \-]?)(\d{4})\b
    Matching
    927 70 5828
    Non matching
    87620
    USA- California State Driver License number State of California, USA driver license number \b[a-zA-Z]\d{7}\b
    Matching
    A0002144
    Non matching
    1111
    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
    Non matching
    1998