摘要
对公民身份证编码规则进行了分析,建立了VBA函数能够将15位转换成18位身份证号,并且能够提示录入错误。提出了由身份证号以及配合一些信息字段,导出到其它字段的实现方法,从而减少了数据的重复录入。软件功能采用Excel实现。
The encoding rule of ID code is analyzed in this thesis. The self-defining function is also established to convert the 15-digit ID code into the 18-digit one, which can suggest input error. The way of extracting other field from ID code and some related field is given, and then repeated input can be reduced. All these functions are realized by means of Microsoft Excel.
作者
马德起
苏明跃
臧世阳
MA De-qi,SU Ming-yue,ZANG Shi-yang （Tianjin Entry-Exit Inspection And Quarantine Bureau, Tianjin 300456,China）
出处
《电脑知识与技术》
2007年第9期1193-1194,1290,共3页
Computer Knowledge and Technology
