ProprDName ( _NameFld ; _Cntr )

Calculates proper Dutch name

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

Henk Wijtman - Show more from this author

Sample input:

ProprDName ( "maarten 't hart , 1 )

Sample output:

Maarten 't Hart

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

/* --------------------PROPER-DUTCH-NAME-----------------------
Custom function to calculate a proper Dutch name. In the Netherlands 
middlenamesoften have 'van 't' or 'van d'r'. And we also have a lot of double 
first names like 'Henk-Jan' or 'Jan-Willem'. In order to input the name in a 
proper way to prevent future problems I wrote this recursive function. 

If exeptional names have to be entered you can write the '!' character in front 
of the name and it will be untouched.

Static parameters '_NamSrc' and '_Antl' are placed inside the function but can 
be placed outside as function parameters. In this way the function becomes 
even smaller and faster.
---------------------------------------------------------------*/


Case ( not IsEmpty ( _NameFld ) ; /*do nothing If field is empty*/
   Case ( Left ( GetValue ( _NameFld ; 1 ) ; 1) <> "!" ; /* check for exception sign '!'*/

      Let ( 
      [
      _NamSrc = Substitute ( Trim ( _NameFld ) ; " " ; "¶" ) ;
      _Antl = ValueCount ( _NamSrc ) ; 
      _TrgtFld = "" ;

      _TrgtFld  = 
           Case ( 
           _Cntr = 1 and _Antl > 1  ; 
           Proper ( GetValue ( _NamSrc ; _Cntr )) & " " & /*FirstName*/
           ProprDName ( _NameFld ; _Cntr + 1 ); 

           _Cntr <> _Antl ; 
           _TrgtFld & Lower ( GetValue ( _NamSrc ; _Cntr )) & " " & /*MiddleName(s)*/
           ProprDName ( _NameFld ; _Cntr + 1 ) ; 

 
           _TrgtFld & Proper ( GetValue ( _NamSrc ; _Cntr ))) 
           /*LastName-norecursion-Dflt-EndCase3*/
      ] 
      ;
      _TrgtFld ) ; /*End Let1*/


   Middle ( _NameFld ; 2 ; Length ( _NameFld ) - 1 )) ; /*Expt-Dflt-EndCase2*/
"" ) /*FldEmpty-Dflt-EndCase1*/

PROPER-DUTCH-NAME
Custom function to calculate a proper Dutch name. In the Netherlands middlenames often have 'van 't' or 'van d'r'. And there are also a lot of double first names like 'Henk-Jan' or 'Jan-Willem'. In order to input the name in a proper way to prevent future problems I wrote this recursive function.

If exeptional names have to be entered you can write the '!' character in front of the name and it will be untouched.

Static parameters '_NamSrc' and '_Antl' are placed inside the function but can be placed outside as function parameters. In this way the function becomes even smaller and faster.

Comments

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

ProprDName ( _NameFld ; _Cntr )

Comments

Support this website.

Support this website.