Video Screencast Help

State Data Privacy- Driv Lic numbers

Created: 11 Mar 2013
stumunro's picture

Dont know how many of you have to use this canned template, but there are a few states in there... 

If you the state you are trying to cover does not have one here is a list i found that may help... this is doen via regex. Cant take credit for this but want to share this info so you dont have the pains i had to go thru...

source:  http://www.sqaforums.com/showthreaded.php?Number=528560

AL Alabama: 7 numeric ^(\d{7})$

AK Alaska: 1-7 numeric ^(\d{1,7})$

AZ Arizona: 9 numeric OR 1 alpha, 8 numeric ^([a-zA-Z0-9]\d{8})$

AR Arkansas: 8 numeric or 9 numeric ^(\d{8,9})$

CA California: 1 alpha, 7 numeric ^([a-zA-Z]\d{7})$

CO Colorado: 1 alpha, 6 numeric OR 9 numeric ^(([a-zA-Z]\d{6})|(\d{9}))$

CT Connecticut: 9 numeric ^([0-2][0-9]\d{7})$

DE Delaware: Unspecified ^\w+$

DC District of Columbia: 9 numeric or 7 numeric ^((\d{7})|(\d{9}))$

FL Florida: 1 alpha, 12 numeric ^([a-zA-Z]\d{12})$

GA Georgia: 7-9 numeric ^(\d{7,9})$

HI Hawaii: 9 numeric ^(\d{9})$

ID Idaho: 6 numeric, 1 alpha OR 9 numeric or 9 alphanumeric ^(([a-zA-Z]{2}\d{6}[a-zA-z])|(\d{9})|(\w{9}))$

IL Illinois: 1 alpha, 11 numeric ^([a-zA-Z]\d{11})$

IN Indiana: 10 numeric OR 9 numeric ^(\d{9,10})$

IA Iowa: 9 numeric OR 3 numeric, 2 alpha, 4 numeric ^((\d{9})|(\d{3}[a-zA-Z]{2}\d{4}))$

KS Kansas: 1 alpha, 8 numeric OR 9 numeric ^(([a-zA-Z]|\d)\d{8})$

KY Kentucky: 9 numeric OR 1 alpha, 8 numeric ^([a-zA-Z0-9]\d{8})$

LA Louisiana: 1-9 numeric ^(\d{1,9})$

ME Maine: 7 numeric possibly followed by an 'X' ^((\d{7})|(\d{7}[xX]))$

MD Maryland: 1 alpha, 12 numeric ^([a-zA-Z]\d{12})$

MA Massachusetts: 1 alpha, 8 numeric OR 9 numeric ^([a-zA-Z0-9]\d{8})$

MI Michigan: 1 alpha, 12 numeric ^([a-zA-Z]\d{12})$

MN Minnesota: 1 alpha, 12 numeric ^([a-zA-Z]\d{12})$

MS Mississippi: 9 numeric ^(\d{9})$

MO Missouri: 1 alpha and 6-9 numeric OR 9-10 numeric OR 9 numeric and 1 alpha OR 1 alpha and 15-16 numeric OR 1 alpha and 15 numeric and 1 alpha ^(([a-zA-Z]\d{6,9})|(\d{9,10})|(\d{9}[a-zA-Z])|([a-zA-Z]\d{15,16})|([a-zA-Z]\d{15}[a-zA-Z]))$

MT Montana: 1 alpha, 6 numeric OR 9 numeric, 1 alpha, 1 numeric, 1 alpha, 2 numeric, 3 alpha and 1 numeric ^(([a-zA-Z]\d{6})|(\d{9})|([a-zA-Z]\d[a-zA-Z0-9]\d{2}[a-zA-Z]{3}\d))$

NE Nebraska: 1 alpha (A,B,C,E,G,H,V), 3-8 numeric ^([ABCEGHVabceghv]\d{3,8})$

NV Nevada: 9 numeric OR 12 numeric OR 'X' and 8 numeric OR 10 numeric ^((\d{9,10})|(\d{12})|([xX]\d{8}))$

NH New Hampshire: 2 numeric, 3 alpha, 5 numeric ^(\d{2}[a-zA-Z]{3}\d{5})$

NJ New Jersey: 1 alpha, 14 numeric ^([a-zA-Z]\d{14})$

NM New Mexico: 9 numeric ^(\d{9})$

NY New York: 9 numeric OR 1 alpha, 18 numeric ^((\d{9})|([a-zA-Z]\d{18}))$

NC North Carolina: 1-8 numeric ^(\d{1,8})$

ND North Dakota: 9 numeric ^(\d{9})$

OH Ohio: 9 numeric OR 2 alpha, 6 numeric ^((\d{9})|([a-zA-Z]{2}\d{6}))$

OK Oklahoma: 9 numeric ^(\d{9})$

OR Oregon: 1-7 numeric ^(\d{1,7})$

PA Pennsylvania: 8 numeric ^(\d{8})$

RI Rhode Island: 7 numeric OR 'V' and 6 numeric ^([0-9vV]\d{6})$

SC South Carolina: 6-9 numeric, cannot begin with '6' or '9' ^([0-57-8][0-8][0-57-8]\d{3,6})$

SD South Dakota: 6-9 numeric OR 11 numeric ^((\d{6,9})|(\d{11}))$

TN Tennessee: 7-9 numeric ^(\d{7,9})$

TX Texas: 8 numeric beginning with 0, 1 or 2 ^([0-2]\d{7})$

UT Utah: 4-10 numeric ^(\d{4,10})$

VT Vermont: 8 numeric OR 7 numeric, letter 'A' ^(\d{7}[0-9Aa])$

VA Virginia: 9 numeric OR 1 alpha (A,R,T), 8 numeric ^([0-9rRtTaA]\d{8})$

WA Washington: 5 alpha(lastname), 1 alpha(first<br>name), 1 alpha(middlename), 3 numeric, 2 alphanumeric. If lastname or<br>middlename fall short, fill with * ^([a-zA-Z*]{5}[a-zA-Z][a-zA-Z*]\d{3}[a-zA-Z0-9]{2})$

WV West Virginia: 1 alphanumeric, must be<br>either 0 or A,B,C,D,E,F,S and 6 numeric OR<br>must be 1X and 5 numeric OR letters "XX" and 5 numeric ^(([0a-fA-FsS]\d{6})|(1[xX]\d{5})|([xX]{2}\d{5}))$

WI Wisconsin: 1 alpha, 13 numeric ^([a-zA-Z]\d{13})$

WY Wyoming: 9-10 numeric ^(\d{9,10})$