Hi Mark,
I'm including a sample scan of two successes PDF code (below) as well as the data indicators for other states. This small sample containts a NY State address and a PA address (actual addresses modified for privacy)
AAMVA36001001DL00270249DL
DAAORTIZ@ALAN
DAG3914 8TH AVE APT L4
DAIBROOKLYN
DAJNY
DAK11551
DAQ737596158
DBB19790403
DBD20000306
DBA20040403
DARD
DAS
DAT
DBCM
DAU507
DAYBR
DBK
DBH @
AAMVA6360250101DL00290184DAQ24474215
DAAERIC VEDRZEJ
DAG3901 SHETLAND AVE
DAIPHILADELPHIA
DAJPA
DAK19156
DAR--
DAS*/*
DAT----
DAU602
DAYHAZ
DBA20051031
DBB19770622
DBCM
DBD20020216
DBF01
DBHN@
I scan in about 200 - 300 driver license barcodes during the night...as I mentioned before, the raw data just gets dumped into a notepad application (I usually need to let is sit for a couple of hours after I'm done because the data apparently gets buffered somewhere and takes quite some time to get into notepad.)
I'd like to create a program that collects the data on the Symbol, and then at some point (I'm not sure when is best) parses the data and generate a tab-delineated file such as:
FIRSTNAME MIDDLE LASTNAME ADDRESS CITY STATE ZIP DOB
First example would be:
ALAN(TAB)ORTIZ(TAB)3914 8TH AVE APT L4(TAB)BROOKLYN(TAB)NY(TAB)11551(TAB)04/03/79
My priority is extracting the NY records, but I'm listing the data formats for all of the states that I know, in the event you might have use for them.
***
Each records appears to begin with either:
AAMV????
Or
ANSI as described below.
NEW YORK STATE
For the records beginning with AAMVA36001, these are New York State records:
The first field (name) is noted with “DAA” immediately preceeding the data. The “@” sign is used as a space with the following format LASTNAME@FIRSTNAME@MIDDLENAME (with the middle name being optional)
“DAG” starts the line with the address
“DAI” starts the line with the city
“DAJ” starts the line with the state
“DAK” starts the line with the zip
“DBB” starts the line with the date of birth in this format “YYYYMMDD”
The other fields are not important. On occasion, some of the above fields may be blank.
PHILADELPHIA
For the records beginning with AAMVA636025, these are Pennsylvania State records.
Records same as New York State with exception in name field:
The first field (name) is noted with “DAA” immediately preceeding the data. The format is a simple FIRSTNAME MIDDLENAME LASTNAME with a single space between each.
CONNECTICUT
For records beginning with AAMVA636006
Same as New York State with exception in name and zip formats:
First field (name) noted with DAA and format is LASTNAME,FIRSTNAME (comma between two with no space).
Zip is 9 digit 000000000 (no dash)
COLORADO STATE
For records beginning ANSI 636020…, these are Colorado State records following this format:
DAA name (no @ sign, simply spaces as FIRSTNAME MIDDLE LASTNAME)
DAL address
DAN city
DAO state
DAP zip
DBB date of birth “YYYYMMDD”
VIRGINIA STATE
For records beginning ANSI 63600001…, these are Virginia State records following the same format as New York with a format exception for the name…
DAA name (LASTNAME, FIRSTNAME MIDDLE) format uses comma+space after last name, and space between first and middle.
DAK is the zip and is a 9-digit zip code (New York State uses 5 digit)
SOUTH CAROLINA
For records beginning ANSI 6360050
Identical to Virginia with following exception:
Zip code is also 9-digit but is in the form 0000000000 (9 digit, no dashes). If only 5 digit zip code provided, would read 100120000 (with four zeroes tagged onto end). Therefore, four zeroes at end of zip code should be lopped off and ignored.
ARIZONIA
For records beginning ANSI 636026
Same as New York with following differences:
DAA has name FIRSTNAME MIDDLE LASTNAME like Colorado
These fields are also broken out individually under dabLASTNAME dacFIRSTNAME dadMIDDLENAME
UNKNOWN STATE
Record begins with: AAMVA36038
DAA has name in format FIRSTNAME MIDDLE LASTNAME (space delineation)
And DBB has date of birth.
No other fields.