Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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