Brian Dunning's FileMaker Custom Functions

ValidateMagStripes ( Track1 ; Track2 ; Track3 )

Validates data integrity of magnetic stripe tracks.

  Average rating: 4.7 (48 votes) Log in to vote

Tim Griffith   Tim Griffith

Share on Facebook Share on Twitter

  Sample input:
ValidateMagStripes ( MyTrack1 ; MyTrack2 ; MyTrack3 )
  Sample output:
Track 1; Character content 'Valid'; Length is within limits.
This is not Track 2!; Invalid characters in Track 2; Length is within limits.
Track 3 not available

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Validate Magnetic Stripe Tracks

Author: Tim Griffith

Format: ValidateMagStripes ( Track1 ; Track2 ; Track3 )

This will analyze the data intended for encoding onto,
or retrieval from, the tracks of a magnetic stripe on, for
example, a plastic card. It will identify character input
problems such as invalid ASCII characters per track,
test for data length per track, and determine if starting
and ending sentinels are correct per track.

The calculated result is three lines of text separated by
carriage returns (so expand your text result field to
view all calculated lines).

When testing for data length I have not taken into account
the LRC, since it is never a part of data encoding, and never
a product of reading the mag stripe (within the sentinels).

 

Comments

wlnys chan   wlnys chan, china
Jan 7, 2015
4028570900232713=16092011495571700000
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.