Milyli Support

Milyli Support

  • User Guides
  • Resources
  • Videos
  • Schedule Training

›Regular Expressions

Home

  • Getting Started

Certification

  • BCE - FAQ

Regular Expressions

  • General PII
  • Financial Accounts
  • Government Ids

Resources

  • CSV Import Templates
  • dtSearch Syntax Characters

Financial Accounts

Credit cards

If using the regular expressions below for a Blackout image project, results may be improved by being defensive against common OCR mistakes. Each instance of the any digit match can be replaced with a character replacement pattern that will evaluate numbers as common alphanumeric characters.

To do so simply replace the \d pattern with [\dOIlZEASB]. This type of defensive matching is not typically needed for Excel.

Visa, MasterCard, AmEx

\b((4\d{3}|5[1-5]\d{2}|2\d{3}|3[47]\d{1,2})[\s\-]?\d{4,6}[\s\-]?\d{4,6}?([\s\-]\d{3,4})?(\d{3})?)\b

This regular expression matches the following samples.

Visa

  • 4532613257548007
  • 4716563756075937
  • 4929038415234561233
  • 4718 4123 4142 4124
  • 4716-5637-5607-5937

MasterCard

  • 2720-9928-3988-7281
  • 2720992839887281
  • 5461718001676921
  • 5489790994470834
  • 5489 7909 9447 0834
  • 5489-7909-9447-0834

AmEx

  • 372714876128394
  • 346781676352683
  • 376506566639896
  • 3765 065666 39896
  • 3467 816763 52683
  • 3400 0000 0000 009

Individual brand credit cards

CardRegex
Amex Card\b3[47][0-9]{13}\b
BCGlobal\b(6541|6556)[0-9]{12}\b
Carte Blanche Card\b389[0-9]{11}\b
Diners Club Card\b3(?:0[0-5]|[68][0-9])[0-9]{11}\b
Discover Card\b65[4-9][0-9]{13}|64[4-9][0-9]{13}|6011[0-9]{12}|(622(?:12[6-9]|1[3-9][0-9]|[2-8][0-9][0-9]|9[01][0-9]|92[0-5])[0-9]{10})\b
Insta Payment Card\b63[7-9][0-9]{13}\b
JCB Card\b(?:2131|1800|35\d{3})\d{11}\b
Korean Local Card\b9[0-9]{15}\b
Laser Card\b(6304|6706|6709|6771)[0-9]{12,15}\b
Maestro Card\b(5018|5020|5038|6304|6759|6761|6763)[0-9]{8,15}\b
MasterCard\b(?:4[0-9]{12}(?:[0-9]{3})?|[25][1-7][0-9]{14}|6(?:011|5[0-9][0-9])[0-9]{12}|3[47][0-9]{13}|3(?:0[0-5]|[68][0-9])[0-9]{11}|(?:2131|1800|35\d{3})\d{11})\b
Solo Card\b(6334|6767)[0-9]{12}|(6334|6767)[0-9]{14}|(6334|6767)[0-9]{15}\b
Switch Card\b(4903|4905|4911|4936|6333|6759)[0-9]{12}|(4903|4905|4911|4936|6333|6759)[0-9]{14}|(4903|4905|4911|4936|6333|6759)[0-9]{15}|564182[0-9]{10}|564182[0-9]{12}|564182[0-9]{13}|633110[0-9]{10}|633110[0-9]{12}|633110[0-9]{13}\b
Union Pay Card\b(62[0-9]{14,17})\b
Visa Card\b4[0-9]{12}(?:[0-9]{3})?\b
Visa Master Card\b(?:4[0-9]{12}(?:[0-9]{3})?|5[1-5][0-9]{14})\b

American Banker Association (ABA) transit routing numbers

\b((0[0-9])|(1[0-2])|(2[1-9])|(3[0-2])|(6[1-9])|(7[0-2])|80)([0-9]{7})\b

This regular expression matches the following ABA routing numbers.

  • 011103093
  • Florida 067014822
  • Maine 211274450
  • Massachusetts/Rhode Island 211370545
  • Metro DC/Maryland/Virginia 054001725
  • New Hampshire 011400071
  • New Jersey/Delaware 031201360
  • New York – Metro NYC or former Commerce customers 026013673
  • New York – Upstate NY or former Banknorth customers 021302567
  • North Carolina/South Carolina 053902197
  • Pennsylvania 036001808
  • Vermont 011600033

SWIFT Code

This regular expression can be used to redact SWIFT codes for payment instruction information.

\b[A-Z]{6}[A-Z0-9]{2}([A-Z0-9]{3})?\b

IBAN Codes

This regular expression can be used to redact IBAN codes for payment instruction information.

(?:(?:IT|SM)\d{2}[\w]\d{22}|CY\d{2}[\w]\d{23}|NL\d{2}[\w]{4}\d{10}|LV\d{2}[\w]{4}\d{13}|(?:BG|BH|GB|IE)\d{2}[\w]{4}\d{14}|GI\d{2}[\w]{4}\d{15}|RO\d{2}[\w]{4}\d{16}|KW\d{2}[\w]{4}\d{22}|MT\d{2}[\w]{4}\d{23}|NO\d{13}|(?:DK|FI|GL|FO)\d{16}|MK\d{17}|(?:AT|EE|KZ|LU|XK)\d{18}|(?:BA|HR|LI|CH|CR)\d{19}|(?:GE|DE|LT|ME|RS)\d{20}|IL\d{21}|(?:AD|CZ|ES|MD|SA)\d{22}|PT\d{23}|(?:BE|IS)\d{24}|(?:FR|MR|MC)\d{25}|(?:AL|DO|LB|PL)\d{26}|(?:AZ|HU)\d{27}|(?:GR|MU)\d{28})
← General PIIGovernment Ids →
  • Credit cards
    • Visa, MasterCard, AmEx
    • Individual brand credit cards
  • American Banker Association (ABA) transit routing numbers
  • SWIFT Code
  • IBAN Codes
Milyli Support
Learn
User guidesResourcesVideos
Explore
About MilyliCase Studies
Connect
TwitterLinkedInCareers
Copyright © 2023 Milyli, Inc