身分証明書番号から自動的に生肖を計算する

干支の計算ロジックは生まれた年(7 ~ 10位) 12に余りを求めて生肖を判断する生分証番号の7 ~ 12桁は、その身分証明書に対応するメンバーの誕生年である。

1.if関数計算

If関数で様々な状況をリストアップし、状況に合ったものは自動的に干支を計算する

次のコードは公式エディタに直接コピーできます身分証明書番号フィールドの置き換えに注意してください。

{"text":"IF(EQ(LEN(​身份证号​),18),IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),0),\"猴\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),1),\"鸡\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),2),\"狗\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),3),\"猪\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),4),\"鼠\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),5),\"牛\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),6),\"虎\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),7),\"兔\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),8),\"龙\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),9),\"蛇\",IF(EQ(MOD(VALUE(MID(​身份证号​,7,4)),12),10),\"马\",\"羊\"))))))))))),\"\")","marks":[{"from":{"line":0,"ch":10,"sticky":null},"to":{"line":0,"ch":16,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":42,"sticky":null},"to":{"line":0,"ch":48,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":86,"sticky":null},"to":{"line":0,"ch":92,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":130,"sticky":null},"to":{"line":0,"ch":136,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":174,"sticky":null},"to":{"line":0,"ch":180,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":218,"sticky":null},"to":{"line":0,"ch":224,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":262,"sticky":null},"to":{"line":0,"ch":268,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":306,"sticky":null},"to":{"line":0,"ch":312,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":350,"sticky":null},"to":{"line":0,"ch":356,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":394,"sticky":null},"to":{"line":0,"ch":400,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":438,"sticky":null},"to":{"line":0,"ch":444,"sticky":null},"value":"textField_ksfyitkm","invalid":false},{"from":{"line":0,"ch":482,"sticky":null},"to":{"line":0,"ch":488,"sticky":null},"value":"textField_ksfyitkm","invalid":false}],"isCmData":true}

If (条件を判断し、結果がtrueの戻り値、結果がfalseの戻り値)
Eq (value 1、value 2) の2つの値が等しい場合はtrueを返し、数字、日付をサポートします
Len (text):テキスト文字列中の文字数を返します
Value (): mid関数が取り出した文字列を数字に変換します
Mod (number、divisor): 2つの数を割った余りを返します
Mid (a、b、c): a文字列で、b番目からc文字を取り出します