I am swiping magnetic card, and my swipe reader is displaying all 3
tracks of information, I wanted to know how to take that information
that looks like this:


E?;123456789=1?E? and want to know what my calculation field would
look like to parse it down to just the 9 digit number and the =1 ?


thanks in advance for your help

Is the information always in that configuration?

If it is always the same number of characters, then the simplest would be

Number = Middle ( Swipe ; 4 ; 11 )

In English, 11 characters from the middle of Swipe, starting at the 4th
character.

If it is always an E as the leading and trailing alpha, you could also
do it with

Number =
Substitute ( Swipe ;
[ "E?;" ; "" ] ;
[ "E?" ; "" ] )

In English, Substitute null for the characters you don't want.

Matt


In article <1162502861.202144.15270 (AT) k70g2000cwa (DOT) googlegroups.com>,
"sasampson (AT) gmail (DOT) com" <sasampson (AT) gmail (DOT) com> wrote:

That worked perfect, thanks for that help!


Matt Wills wrote: