Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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})$