IsValidSofiNumber ( sofinummer )

Checks a Dutch sofinumber for validity.

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

Theo Ros - Show more from this author

Sample input:

IsValidSofiNumber ( "123456789" )

Sample output:

false

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

/*-------------------------------------------------------
Checks a Dutch sofinumber for validity.
Syntax: IsValidSofiNumber ( sofinummer )
Returns "true" if sofinummer passes the '11-proef', 
"false" if not or an empty string if sofinummer is empty.
Author - Theo Ros
----------------------------------------------------------*/

If ( IsEmpty ( sofinummer ) ; "" ;
  Let ( sNumber = Filter ( sofinummer ; "0123456789" ) ;
    If ( Length ( sNumber ) < 1 or Length ( sNumber ) > 9 ; "false";
      Let ( nNumber = Right( "000000000" & sNumber ; 9 ) ;
        If ( GetAsNumber( Right( nNumber ; 1) ) = Mod (
          GetAsNumber( Middle( nNumber ; 1 ; 1) ) * 9 + 
          GetAsNumber ( Middle( nNumber ; 2; 1) ) * 8 + 
          GetAsNumber ( Middle( nNumber ; 3; 1) ) * 7 + 
          GetAsNumber ( Middle( nNumber ; 4; 1) ) * 6 + 
          GetAsNumber ( Middle( nNumber ; 5; 1) ) * 5 + 
          GetAsNumber ( Middle( nNumber ; 6; 1) ) * 4 + 
          GetAsNumber ( Middle( nNumber ; 7; 1) ) * 3 + 
          GetAsNumber ( Middle( nNumber ; 8; 1) ) * 2 ; 11 ) ; "true"; "false"
        )
      )
    )
  )
)

Returns "true" if sofinummer passes the '11-proef',
"false" if not or an empty string if sofinummer is empty.

Comments

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

IsValidSofiNumber ( sofinummer )

Comments

Support this website.

Support this website.