DriversLicenseData ( Value ; Field )

Extract Data from Drivers License 2D barcode

Be the first to rate this function Log in to vote

Bill Koller - Show more from this author
Anchor Consulting LLC

Sample input:

DriversLicenseData ( "FirstName"; ScannedData)

Sample output:

William

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.

--- Values ---
FirstName	
LastName	
MiddleName	
ExpDate	
IssueDate	
DOB
Gender	
EyeColor	
Height
StreetAdd
City	
State	
Zip
*/


Let ( [
Data =Case ( 
Value= "FirstName";"DAC";
Value= "LastName";"DCS";
Value= "MiddleName";"DAD";
Value= "ExpDate";"DBA";
Value= "IssueDate";"DBD";
Value= "DOB";"DBB";
Value= "Gender";"DBC";
Value= "EyeColor";"DAY";
Value= "Height";"DAU";
Value= "StreetAdd";"DAG";
Value= "City";"DAI";
Value= "State";"DAJ";
Value= "Zip";"DAK";

 )
;


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

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

Extract Data from 1 field with scanned data from the barcode on the back of a drivers license

Comments

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

DriversLicenseData ( Value ; Field )

Comments

Support this website.

Support this website.