All,
Is there some standard code that breaks out the data from a driver's license scan into the different fields of data? (First Name, Middle Name, Last Name, License Number, Street Address, City, State, Zip, Birth-date, Expiration Date, Sex, Height, Weight, Eye Color, Restrictions and Endorsements).

I can scan the 2D bar-code or magnetic strip, but the data scans in as ANSI format with special characters between the fields.

I have not created the table yet, so I can name it and the fields to match what the scan is telling me.