Brian Dunning's FileMaker Custom Functions

CheckIBAN ( IBAN )

Checks whether the IBAN is correct or not

  Average rating: 4.1 (47 votes) Log in to vote

Christoph Kaufmann   Christoph Kaufmann
CLK.ch
http://clk.ch

Share on Facebook Share on Twitter

  Sample input:
CH65 0900 0000 3011 5642 8
  Sample output:
1

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

International Bank Account Numbers (IBAN) start with the country code and two figures, such as CH12. The function checks whether the these figures are correct or not. If not, the function returns 0. In that case, the IBAN is not correct and any attempt to make a payment with this IBAN will fail.

 

Comments

Ralph Nusser   Ralph Nusser, Switzerland
Mar 12, 2009
Alternative calculation at:
http://www.filemaker-magazin.de/abcms/fc0002761.html
V 1.2 April 2007
Autor: Klaus-Dieter Brügmann, www.kade-project.de. <http://www.kade-project.de.> August 2006
 
Pascal   Pascal, Italy
Apr 15, 2012
Grüezi.
Danke for your work. I put the function in my database and it works fine.
Uf widerluege.
 
Chrystel   Chrystel, Antibes
Jul 22, 2013
Hello,
Sorry I do not speak English.
My problem: I need to create a function to calculate the IBAN key and I am a beginner in Filemaker. My company uses an old version of Filemaker is 5.5 pro FM. Can you help me? Thank you in advance.
 
wwdto   wwdto, munich
Feb 17, 2014
Works fine, but returns 1, even when DE-IBANs are too long with appended zeros.
 
Arjen van der Ree   Arjen van der Ree, Amsterdam
Apr 9, 2014
Great Work Christof,

this IBAN check works also on dutch IBAN-codes. Those are a little different from Swiss or German codes because they have 2 books with letters in them: e.g. NL75INGB0005151989.

Your code was simple and spot-on !

Regards,
Arjen van der Ree
Maxperts
Amsterdam
 
Christoph Kaufmann   Christoph Kaufmann, CLK.ch
Jan 15, 2015
Changes on Jan 15, 2015:
- use local variables instead of script ($) variables
- Allow all characters except spaces since I need to check them all
- Filemaker ignores characters that are not numbers when calculating mod. Added a check for unallowed characters at the end.
- Experimented with DE-IBANS which "were too long with appended zeros", couldn't replicate any error. Please forward the IBAN in question.

Weakness: No checks for leading and trailing spaces, those may affect the IBAN. Use Trim or Supertrim in Auto-Enter.
 
Lutz Cleffmann   Lutz Cleffmann, Düsseldorf, Germany
Jan 23, 2015
Works fine with my database.
Just a tiny bug: If you enter just the number "1" in the field the function returns also "1" for a correct IBAN. All other numbers and characters are recognized correctly as false.
 
Christoph Kaufmann   Christoph Kaufmann, CLK.ch
Jan 23, 2015
Added check for a minimum of 6 characters. Thanks to Lutz Cleffmann.
 
Christoph Kaufmann   Christoph Kaufmann, CLK.ch
Jan 23, 2015
Chrystel wrote from Antibes:

> My company uses an old version of Filemaker is 5.5 pro FM.

This .fp5 solution uses a file and a script to check any IBAN:
http://clk.ch/clk-ezag/ezag166.zip
 
Claudius von Wrochem   Claudius von Wrochem, berlin
Mar 5, 2018
z instead of p

IBAN = Filter ( IBAN ; "1234567890abcdefghijklmnopqrstuvwxy !!! p !!! ABCDEFGHIJKLMNOPQRSTUVWXYZ " ) // IBAN enthält keine Schweinereien; Leerschläge bleiben erlaubt.
)
)
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.