The principle and method of 10-digit EM card to 8-digit card number

 DOWNLOAD

principle:
The 8-digit card number is the wiegand26 international standard card number output method. Some domestic attendance machine manufacturers use the method of directly reading the internal code of the card number to make the card number. This reading method is 10 digits.
For example, a card is printed as follows:
0013961168 213 02000
10-digit card number 3+5 8-digit card number
The 10-digit card number 0013961168 converted to hexadecimal is 00 D5 07 D0
8-digit card number 213 02000 The first 3 digits of 213 converted to hexadecimal is D5 The last five digits of 02000 converted to hexadecimal is 07 D0

You can find the rule: First, 10 digits are converted into hexadecimal, which is 4 bytes, the first byte is not needed, the second byte is converted into the first 3 digits of the 8-digit card number, the third and fourth characters Sections together convert the last 5 digits of the 8-digit card number.


Excel conversion formula:
=(MOD(X,256*256))+(MOD(INT(X/(256*256)),256)*100000) X represents ten digits, the result is 8 digits


excel conversion case
See attached file UsersInfo.xls