Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here in Texas our Drivers license has a mag stripe on the back with all the
D.L. information. I need to be able to swipe the D.L. an have the information go into ExCell cells. Here is what I get when I swipe a D.L.: %TXDALLAS^BLOW$JOE$DAN^123 SOMESTREET^?;63601512345678=060919740927? (THIS IS ALL ONE LONG STRING. THE FORMATING HERE IN THE QUESTION BOX IS SCREWING IT UP) After the "%" is the state and city. Between the first "^" and second "^" is lastname firstname midname with a "$" as the seperator. Between the second "^" and the third "^" is their address. After the third "^" is "?;" then their D.L. number until you get to the "=". The first four digits after the "=" is the expiration date of their D.L. The last eight digits is their birthday in the format YYYYMMDD. And then finially a "?" that ends the string. Anyone have a good way to seperate this all out? H.W. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Entering Excel information into MS Word | Excel Discussion (Misc queries) | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
Excel - counting cells containing a text string | Excel Worksheet Functions | |||
Extract hyperlink string from excel cell | Links and Linking in Excel |