AnsweredAssumed Answered

Magnetic Card Reader

Question asked by JimmyMadison on Dec 20, 2013
Latest reply on Jan 3, 2014 by JimmyMadison

I have a file which I need to populate AL Drivers License information into. I am using a Magtek card reader which I have working well and storing the card string into a text field. Listed below is an dummy example of the data that is stored in the field:


%ALARLEY^LAST_NAME$FIRST_NAME$M_NAME^1169 COUNTY ROAD 4221^?;6360333096123=150719530806=?#10355412379 DM M511205BROBLU?


The blank space in front of the "DM" and after all apear to be just blank space.


I have read the Left, Right, and Middle calulations and it has me very confused. Can someone please send me in the right direction on how to populate the above string into seperate fields such as First_Name, M_Name,Last_Name, Address, and so on. Thanks for your assistance. JM