This is a public Forum  publicRSS

Forum post

    kriston renshaw
    Mod 97-10? - IBAN Calculation
    Forum post posted August 17, 2011 by kriston renshaw, last edited February 9, 2012 
    2279 Views, 2 Comments
    Title:
    Mod 97-10? - IBAN Calculation
    Post:

    Hi again!

    I have managed to create an IBAN calculator on EXCEL using Mod97 splitting the modulus of the IBAN into 9 digits etc etc.

    The checksum is calculated from the following:

    Country Code

    Bank Code

    Bank Branch

    Account number

    The checksum are 2 digits that validate the code.

    IBAN:       GB00 WEST 1234 5698 7654 32
    Rearrange:   W E S T12345698765432 G B00
    Modulus:    3214282912345698765432161100 mod 97 = 16  
    Check Sum: 98-16 = 82

    IBAN:       GB82 WEST 1234 5698 7654 32
    

    I want to apply this to Filemaker and want to ask if anyone here has had experience somehow using Mod 97 if it is at all possible in Filemaker Pro 11.  

    I would rather not waste my time if it is not possible.

    Answer

     

    • PhilModJunk

      FileMaker also has a Modulus function.

      Mod ( 3214282912345698765432161100 ; 97 ) will evaluate as 16.

    • kriston renshaw

      thank you Phil!

       

      I am not sure how or why I did not see the MOD function?!?!?!  But now I see it... I will slow down next time  :)