CheckIBAN ( IBAN )

check if given iban number is correct ( EU version )

Average rating: 4.2 (33 votes) Log in to vote

Michael Bijnens
freelance developer
/

Sample input:

CheckIBAN ( BE55000311190144 )

Sample output:

IF CORRECT = 1
"LENGTH ERROR"
"COUNTRY CODE MISSING"
"INCORRECT IBAN"

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

/* ============================================
#
# Purpose:			check IBAN ( international bank account number ).
#
# Arthor:				Michael Bijnens
# Creation date:		01/01/2014
#
# Note:				this version is compatible for all EU countries!
#
=============================================*/


Let (
	[
		iban = Upper ( IBAN ) ;
		iban = Filter ( iban ; "1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ;
		country = Left ( Filter ( iban ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ; 2 ) ;
		length_iban = Length ( iban ) ;

		/* LIST ALL LENGTHS OF EU CODES
		------------------------------ */
		length_check = Case ( 
					country =	"AD" ; 24 ; 
					country =	"BE" ; 16 ; 
					country =	"BA" ; 20 ; 
					country =	"BG" ; 22 ;
					country =	"CY" ; 28 ; 
					country =	"DK" ; 18 ; 
					country =	"DE" ; 22 ; 
					country =	"EE" ; 20 ; 
					country =	"FI" ; 18 ; 
					country =	"FR" ; 27 ; 
					country =	"GI" ; 23 ;
					country =	"GB" ; 22 ;
					country =	"HU" ; 28 ;
					country =	"IS" ; 28 ;
					country =	"IE" ; 22 ;
					country =	"IL" ; 23 ;
					country =	"IT" ; 27 ;
					country =	"HR" ; 21 ;
					country =	"LV" ; 21 ;
					country =	"LI" ; 21 ;
					country =	"LT" ; 20 ;
					country =	"LU" ; 20 ;
					country =	"MK" ; 19 ;
					country =	"MT" ; 31 ;
					country =	"MU" ; 30 ;
					country =	"MC" ; 27 ;
					country =	"ME" ; 22 ;
					country =	"NL" ; 18 ;
					country =	"NO" ; 15 ;
					country =	"AT" ; 20 ;
					country =	"PL" ; 28 ;
					country =	"RO" ; 24 ;
					country =	"SM" ; 27 ;
					country =	"RS" ; 22 ;
					country =	"SK" ; 24 ;
					country =	"SI" ; 19 ;
					country =	"ES" ; 24 ;
					country =	"CZ" ; 24 ;
					country =	"TN" ; 24 ;
					country =	"TR" ; 26 ;
					country =	"SE" ; 26 ;
					country =	"CH" ; 21
					) ;

		/* REARRANGE IBAN
		------------------ */
		iban = Upper (Middle ( iban ; 5 ; length_check - 4 ) & Left ( iban ; 4 )) ;

		/* GET LETTERS FROM IBAN
		------------------------ */
		firstletter = Middle ( iban ; length_check - 3 ; 1 ) ;
		secondletter = Middle ( iban ; length_check - 2 ; 1 ) ;

		/* CONVERT LETTER INTO DIGITS
		----------------------------- */
		letters = "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ;
		firstconvert = Position ( letters ; firstletter ; 1 ; 1 ) + 9 ;
		secondconvert = Position ( letters ; secondletter ; 1 ; 1 ) + 9 ;

		/* MODULO CALCULATION
		----------------------- */
		accountnumber = Left ( iban ; length_check - 4 ) & firstconvert & secondconvert & Right ( iban ; 2 )  ;
		divisor = 97 ;
		result = Mod ( accountnumber ; divisor )
	
	] ;
	
		Case(
			
			IsEmpty ( country ) ;
			"COUNTRY CODE IS MISSING" ;
			length_iban ≠ length_check ;
			"LENGTH ERROR" ;
			result ≠ 1 ;
			"IBAN INCORRECT" ;
			result
		)


)

Michael Bijnens - Junior FileMaker Analyst / Programmer
-------------------------

You can use this custom function to check if the given IBAN number is correct.
Create a calculated field ( e.g. flag_correct_IBAN ) in the same table as your IBAN field. (output of the calculation-field has to be TEXT ).

HOW IT WORKS :
-------------------------
e.g.:

1) given IBAN : BE55000311190144
2) first 4 to the end : "000311190144" & "BE55"
3) convert each letter ( B & E ) to digits. ( A = 10 ; B = 11 ; ... Z = 35 )
4) converted : 11 & 14
5) stich it : "000311190144" & "11" & "14" & "55" = 000311190144111455
6) Mod ( IBAN ; 97 )
7) if result = 1 than its a correct IBAN number

Comments

		wwdto, Munich Feb 17, 2014
CAUTION! this Version this custom function does not work correct, it returns other values than 1 for correct IBANS from DE AT; CH and IT. Thats what I have tested.

		Michael, Belgium Feb 17, 2014
Thats correct. The Custom Function is only tested for Belgian IBANS. I haven't tested IBANS from abroad. I will repost is it if I have time to find out how it works. Greets Michael.

		wwdto, munich Feb 17, 2014
Thanks for your response. You can rename your function to CheckIBAN_BE(IBAN) and nobody will expect another result. If you touch it: Would be fine if also length for the chosen country is checked. So this function could be used for input-testing. Ideal would be an Error-code as return value, e.g 1=ok, 2=length-error, 4=special Charakter in IBAN etc. We already had this: a IBAN was copied from another application into a FileMaker field (WIN), nothing to see, nothing worked, hard to find out. Greetings Wolfgang

		Michael, Belgium Feb 17, 2014
Changed it to an EU version. added: check_length ( check if the length of IBAN number is correct with the given country code ). outputs: 1 = correct iban ; missing country code = if country code is missing it won't be able to check length ) ; incorrect iban = the length is correct but the number is incorrect ; length error = the length of IBAN is incorrect. Grtz Michael

		Arjen van der Ree, Amsterdam Apr 9, 2014
Hi Michael, your solution does not seem to handle dutch bans correctly, probably because those have 2 sets of letterblocks (e.g. NL75INGB0005151989 ). Perhaps something you could look into? With Regards, Arjen van der Ree Maxperts Amsterdam, the Neighbors (Netherlands)

		claude pirlot, Brussels Nov 1, 2015
Thank you very much for the IBAN Checker Have a great week

		Christoph Kaufmann, CLK.ch Apr 13, 2016
The functions says IBAN INCORRECT when it actually is correct: IT06 A081 4034 5200 0000 9060 829 Reason: the function assumes there are but two letters in any IBAN (Position 1 and Position 2). Any IBAN with more than these two letters are wrongly valuated as false. You have to convert every letter into a number. There's an example in http://www.briandunning.com/cf/988

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

CheckIBAN ( IBAN )

Comments

Support this website.

Support this website.