DriversLicenseDataScan ( Value ; Field )

Parse out a 2D scanning of an AAMVA PDF417 using the raw data from the 2D barcode

Be the first to rate this function Log in to vote

Todd Dignan - Show more from this author
Dignan Consulting LLC.
https://dignanconsulting.com/

Sample input:

DriversLicenseDataScan ( DLnum; $var or database field)

Sample output:

B240056 (DLnum = Driver Lic number )

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
Created by Bill Koller October 2021
This function will extract data from each of the following fields on Drivers License AAMVA Standard Data versions 4-8.
Enter from the Value list below the data you wish to extract.

Modified by Todd Dignan for Scanning 2026

Reference Guide: AAMVADLIDCardDesignStandard2025.pdf  https://www.aamva.org/getmedia/99ac7057-0f4d-4461-b0a2-3a5532e1b35c/AAMVA-2020-DLID-Card-Design-Standard.pdf

@  (Compliance Indicator)
ANSI (File Type)  636029090302  (Issuer Identification Number (IIN): 6-digit IIN, AAMVA Version Number 2-digit, Jurisdiction Version Number 2-digits, Number of Entries: ‘02’ (numeric value for # of sub-files in the bar code)(
DL00410280ZO03210015DL  (Sub-file Designator pg80 AAMVADLIDCardDesignStandard2025.pdf)
DAQ		(Driver License)
DAC		(First Name)
DAD		(Middle Name)
DCS		(Last Name)
DCU		(Suffix Name)
DAG		(address)
DAH		(address 2)
DAI		(address city)
DAJ		(address st)
DAK		(address zip)
DCA		(Class of Driver Lic)
DCB		(Jurisdiction Vehicle Class)
DCD		(Jurisdiction Restriction Codes)
DBB		(Date of Birth)
DAU		(Height)
DAW		(Weight)
DAY		(Eye Color)
DBC		(Physical Description Sex  Cardholder’s Sex: 1 = male, 2 = female, 9 = not specified / other)
DBD		(Lic Issued Date)
DBA		(Expiration Date)
DCF		(Document Discriminator)
DCG		(address county)
DCK		(Inventory Control Number)
DDE		(Family Name Truncation)
DDF		(First Name Truncation) 
DDG		(Middle Name Truncation)
DDH		(Under 18 Until)
DDJ		(Under 21 Until)
DDK		(Organ Donor Indicator)
DDL		(Veteran Indicator)
DDA		(Compliance Type)
DDB		(Card Revision Date)
DDD		(Limited Duration Document Indicator - This field is either absent or has the following value: “1” = Temporary Lawful status)
ZOZOA09112019  (Court Restriction Code(s))


Created by Bill Koller October 2021
This function will extract data from each of the following fields on Drivers License AAMVA Standard Data versions 4-8.
Enter from the Value list below the data you wish to extract.

--- Values ---
DLnum = DAQ
FirstName = DAC
FirstNameTrunc = DDF
LastName = DCS
LastNameTrunc = DDE
MiddleName = DAD
MiddleNameTrunc = DDG
ExpDate = DBA
IssueDate = DBD
DOB = DBB
Gender = DBC //(1 = male, 2 = female, 9 = not specified / other)
PhysiDescripSex = DBC //(1 = male, 2 = female, 9 = not specified / other)
EyeColor = DAY
Height = DAU
Hair = DAZ
Weight = DAW			
StreetAdd = DAG
StreetAdd2 = DAH			
City = DAI
State = DAJ"
Zip = DAK
County = DCG
DocDiscr = DCF
InvenControlNum = DCK
ComplianceType = DDA
CardRevDate = DDB
DLClass = DCA
JurisVehClass = DCB
JurisRestricCodes = DCD
Under18Until = DDH
Under21Until = DDJ
OrganDonor = DDK
VeteranIndicator = DDL
LimitedDurDocInd = DDD
*/


Let ( [

Field = Substitute ( Field 
					;["DAQ";"¶DAQ"]
					;["DAC";"¶DAC"]
					;["DAD";"¶DAD"]
					;["DCS";"¶DCS"]
					;["DCU";"¶DCU"]
					;["DAG";"¶DAG"]
					;["DAH";"¶DAH"]
					;["DCA";"¶DCA"]
					;["DAI";"¶DAI"]
					;["DAJ";"¶DAJ"]
					;["DAK";"¶DAK"]
					;["DCB";"¶DCB"]
					;["DAC";"¶DAC"]
					;["DCD";"¶DCD"]
					;["DBB";"¶DBB"]
					;["DAU";"¶DAU"]
					;["DAW";"¶DAW"]
					;["DAY";"¶DAY"]
					;["DBC";"¶DBC"]
					;["DBD";"¶DBD"]
					;["DBA";"¶DBA"]
					;["DCF";"¶DCF"]
					;["DCG";"¶DCG"]
					;["DCK";"¶DCK"]
					;["DDE";"¶DDE"]
					;["DDF";"¶DDF"]
					;["DDG";"¶DDG"]
					;["DDH";"¶DDH"]
					;["DDJ";"¶DDJ"]
					;["DDK";"¶DDK"]
					;["DDL";"¶DDL"]
					;["DDA";"¶DDA"]
					;["DDB";"¶DDB"]
					;["DDD";"¶DDD"]
				);
Data =Case ( 
			 Value= "DLnum";"DAQ"
			;Value= "FirstName";"DAC"
			;Value= "FirstNameTrunc";"DDF"
			;Value= "LastName";"DCS"
			;Value= "LastNameTrunc";"DDE"
			;Value= "MiddleName";"DAD"
			;Value= "MiddleNameTrunc";"DDG"
			;Value= "ExpDate";"DBA"
			;Value= "IssueDate";"DBD"
			;Value= "DOB";"DBB"
			;Value= "Gender";"DBC" //(1 = male, 2 = female, 9 = not specified / other)
			;Value= "PhysiDescripSex";"DBC" //(1 = male, 2 = female, 9 = not specified / other)
			;Value= "EyeColor";"DAY"
			;Value= "Height";"DAU"
			;Value= "Hair";"DAZ"
			;Value= "Weight";"DAW"			
			;Value= "StreetAdd";"DAG"
			;Value= "StreetAdd2";"DAH"			
			;Value= "City";"DAI"
			;Value= "State";"DAJ"
			;Value= "Zip";"DAK"
			;Value= "County";"DCG"
			;Value= "DocDiscr";"DCF"
			;Value= "InvenControlNum";"DCK"
			;Value= "ComplianceType";"DDA"
			;Value= "CardRevDate";"DDB"
			;Value= "DLClass";"DCA"
			;Value= "JurisVehClass";"DCB"
			;Value= "JurisRestricCodes";"DCD"
			;Value= "Under18Until";"DDH"
			;Value= "Under21Until";"DDJ"
			;Value= "OrganDonor";"DDK"
			;Value= "VeteranIndicator";"DDL"
			;Value= "LimitedDurDocInd";"DDD"
 			)
;


Result=Substitute ( GetValue ( Right(Field; Length( Field )- Position (Field; data;1;1)+1); 1); data; "") 
];

If ( Result="@"; ""; Result )
)

This allows the user to extract data from an ID or Lic based on the AAMVA Standard Data using the raw data from the 2D barcode. I have added about 20 more identifiers (tags) to Bill Koller original CF. I have also added reference info to make it easier to manipulate and understand this CF.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

DriversLicenseDataScan ( Value ; Field )

Comments

Support this website.

Support this website.