FormatLicensePlateNL ( input )

Format input for license plate for the Netherland the correct possible way

Be the first to rate this function Log in to vote

MarcNL - Show more from this author
https://www.linkedin.com/in/marc-brunsman-4468a287/

Sample input:

FormatLicensePlateNL ( "x999-xx" )
FormatLicensePlateNL ( "xx99xx" )

Sample output:

X-999-XX
XX-99-XX

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

Let ([
    raw = Filter (Upper ( input ); "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789" ) ;
    len = Length ( raw ) ;
    digits = Filter ( raw ; "0123456789" ) ; 
    letters = Filter ( raw ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) 
] ;

Case (

    /* 2-2-2 */
    len = 6 and

    // 1. XX-99-99
    (Left ( raw ; 2 ) = letters and Right ( raw ; 4 ) = digits) or
    // 2. 99-99-XX 
    (Left ( raw ; 4 ) = digits and Right ( raw ; 2 ) = letters) or
    // 3. 99-XX-99
    (Left ( raw ; 2 ) = Left ( digits ; 2 ) and Middle ( raw ; 3 ; 2 ) = letters and Right ( raw ; 2 ) = Right ( digits; 2 )) or
    // 4. XX-99-XX
    (Left ( raw ; 2 ) = Left ( letters ; 2 ) and Middle ( raw ; 3 ; 2 ) = digits and Right ( raw ; 2 ) = Right ( letters ; 2 )) or
    // 5. XX-XX-99
    (Left ( raw ; 4 ) = letters and Right ( raw ; 2 ) = digits) or
    // 6. 99-XX-XX
    (Left ( raw ; 2 ) = digits and Right ( raw ; 4 ) = letters) 
    ;

    Left ( raw ; 2 ) & "-" &
    Middle ( raw ; 3 ; 2 ) & "-" &
    Right ( raw ; 2 ) ;

    /* 7. 99-XXX-9 */
    len = 6 and
    Left ( raw ; 2 ) = Left ( digits ; 2 ) and
    Middle ( raw ; 3 ; 3 ) = letters and
    Right ( raw ; 1 ) = Right ( digits ; 1 ) ;

    Left ( raw ; 2 ) & "-" &
    Middle ( raw ; 3 ; 3 ) & "-" &
    Right ( raw ; 1 ) ;

    /* 8. 9-XXX-99 */
    len = 6 and
    Left ( raw ; 1 ) = Left ( digits ; 1 ) and
    Middle ( raw ; 2 ; 3 ) = letters and
    Right ( raw ; 2 ) = Right ( digits ; 2 ) ;

    Left ( raw ; 1 ) & "-" &
    Middle ( raw ; 2 ; 3 ) & "-" &
    Right ( raw ; 2 ) ;
    
    /* 9. XX-999-X */
    len = 6 and
    Left ( raw ; 2 ) = Left ( letters ; 2 ) and
    Middle ( raw ; 3 ; 3 ) = digits and
    Right ( raw ; 1 ) = Right ( letters ; 1 ) ;

    Left ( raw ; 2 ) & "-" &
    Middle ( raw ; 3 ; 3 ) & "-" &
    Right ( raw ; 1 ) ;
    
    /* 10. X-999-XX */
    len = 6 and
    Left ( raw ; 1 ) = Left ( letters ; 1 ) and
    Middle ( raw ; 2 ; 3 ) = digits and
    Right ( raw ; 2 ) = Right ( letters ; 2 ) ;

    Left ( raw ; 1 ) & "-" &
    Middle ( raw ; 2 ; 3 ) & "-" &
    Right ( raw ; 2 ) ;

    /* 11. XXX-99-X */
    len = 6 and
    Left ( raw ; 3 ) = Left ( letters ; 3 ) and
    Middle ( raw ; 4 ; 2 ) = digits and
    Right ( raw ; 1 ) = Right ( letters ; 1 ) ;

    Left ( raw ; 3 ) & "-" &
    Middle ( raw ; 4 ; 2 ) & "-" &
    Right ( raw ; 1 ) ;
    
    /* 12. X-99-XXX */
    len = 6 and
    Left ( raw ; 1 ) = Left ( letters ; 1 ) and
    Middle ( raw ; 2 ; 2 ) = digits and
    Right ( raw ; 3 ) = Right ( letters ; 3 ) ;

    Left ( raw ; 1 ) & "-" &
    Middle ( raw ; 2 ; 2 ) & "-" &
    Right ( raw ; 3 ) ;
        
    /* 13. 9-XX-999 */
    len = 6 and
    Left ( raw ; 1 ) = Left ( digits ; 1 ) and
    Middle ( raw ; 2 ; 2 ) = letters and
    Right ( raw ; 3 ) = Right ( digits ; 3 ) ;

    Left ( raw ; 1 ) & "-" &
    Middle ( raw ; 2 ; 2 ) & "-" &
    Right ( raw ; 3 ) ;
            
    /* 14. 999-XX-9 */
    len = 6 and
    Left ( raw ; 3 ) = Left ( digits ; 3 ) and
    Middle ( raw ; 4 ; 2 ) = letters and
    Right ( raw ; 1 ) = Right ( digits ; 1) ;

    Left ( raw ; 3 ) & "-" &
    Middle ( raw ; 4 ; 2 ) & "-" &
    Right ( raw ; 1 ) ;


    /* fallback → just uppercase + without dashes */
    raw
))

Get your input back correctly so you can display the license plate correctly according to the license plate formats that apply until at least 2025.

Comments

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

FormatLicensePlateNL ( input )

Comments

Support this website.

Support this website.