So first I would like to thank any of you that can help me with this task. I am trying to extract the data from a drivers lic and auto fill into my contacts table. My 3 track mag swiper works great and gives me this to work with
%CAFAIRFIELD^LASTNAME$FIRSTNAME$MIDDLENAME^STREET ADDRESS LINE1^?;636014025732536=130219790227?+!!94533 C M511240BRNBRN D62120040521 N['&QP0)<7=?
I found this document on the format. So getting the state data was easy with a Left calc., but that's where I scratch my head on where to go next. I think it will use the Middle and maybe Getvalue. Not sure how to put it together tho. All the areas in BLUE are areas that i need to extract. Any thoughts or ideas would be great.
|Drivers License's Format|