完整支持16-19位银号卡号校验位计算:
text(mod((left(right($MF(账号)$,3),1)+left(right($MF(账号)$,5),1)+left(right($MF(账号)$,7),1)+left(right($MF(账号)$,9),1)+left(right($MF(账号)$,11),1)+left(right($MF(账号)$,13),1)+left(right($MF(账号)$,15),1)+mod(left(right($MF(账号)$,2),1)*2,10)+int(left(right($MF(账号)$,2),1)*2/10)+mod(left(right($MF(账号)$,4),1)*2,10)+int(left(right($MF(账号)$,4),1)*2/10)+mod(left(right($MF(账号)$,6),1)*2,10)+int(left(right($MF(账号)$,6),1)*2/10)+mod(left(right($MF(账号)$,8),1)*2,10)+int(left(right($MF(账号)$,8),1)*2/10)+mod(left(right($MF(账号)$,10),1)*2,10)+int(left(right($MF(账号)$,10),1)*2/10)+mod(left(right($MF(账号)$,12),1)*2,10)+int(left(right($MF(账号)$,12),1)*2/10)+mod(left(right($MF(账号)$,14),1)*2,10)+int(left(right($MF(账号)$,14),1)*2/10)+mod(left(right($MF(账号)$,16),1)*2,10)+int(left(right($MF(账号)$,16),1)*2/10)+if(len($MF(账号)$)>=17,left(right($MF(账号)$,17),1),0)+if(len($MF(账号)$)>=18,mod(value(left(right($MF(账号)$,18),1))*2,10)+int(value(left(right($MF(账号)$,18),1))*2/10),0)+if(len($MF(账号)$)>=19,left(right($MF(账号)$,19),1),0))*9,10),0)
配图
配合银行BIN码的检查,就可以知道银行卡是出自哪个银行。
非常荣兴本贴被发布到魔方网表的微信上,有点高兴哦!~~ |