Transponder Code Validation

The following functions allow you to validate that an input matches the pattern of a valid RACE RESULT Active Transponder code, for example if participants are required to enter an individual transponder code during registration. Note it does not truly validate if it is a valid Transponder code. 

If you are using Check-In kiosks to assign transponders then it may be easier to use the option to only allow transponders which are in the chip file to validate against your own stock of transponders. You can import a chip file with all bibs set to 0 for this. 

This can be entered as a User-Defined Function which takes an input to validate the value entered. 

Create a user-defined for isTransponder(x), or an applicable function name with the following expression, this checks that the length is 7 characters, the first 5 digits should be letters and the last 2 digits should be numbers.

Len([x])=7 AND isAlpha(left([x];5))=1 AND isNumeric(right([x];2))=1

e.g. isTransponder([Transponder1]) would return 1 if the value in Transponder1 matches this pattern.