VatFormat ( vat ; country )

Correct the format of a VAT number ( BE, NL & DE )

Average rating: 4.5 (31 votes) Log in to vote

Michael Bijnens
freelance developer
/

Sample input:

1)
VatFormat ( 987 654 321 )
2)
VatFormat ( NL 123.456.789B01 )

Sample output:

1)
BE 0987.654.321
2)
NL123456789B01

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

/* ============================================
#
# Purpose:			check VAT format ( Belgium, Netherlands and Germany )
#
# Arthor:				Michael Bijnens
# Creation date:		01/01/2014
#
# Note:				this function converts the given vatnumber into a regulated (formatted) vatnumber
#
=============================================*/


Let ( 
	[ 
		vat_c = Filter ( vat ; "0123456789" ) ; 
		length = Length ( vat_c ) ;
		country = Filter ( country ; "BENLDE" ) ;
		country = TextStyleAdd ( country ; "Uppsercase" )

	] ;

		Case (
			
			/* BELGIUM
			----------- */
			country = "BE" and length = 9 ;
			country & " 0" & Left ( vat_c ; 3 ) & "." & Middle ( vat_c ; 4 ; 3 ) & "." & Right ( vat_c ; 3 ) ;

			/* NETHERLANDS
			---------------- */
			country = "NL" and length = 11 ;
			country & Left ( vat_c ; 9 ) & "B" & Right ( vat_c ; 2 ) ;

			/* GERMANY
			----------- */
			country = "DE" and length = 9 ;
			country & Left ( vat_c ; 9 ) ;

			/* IF WRONG > RED TEXT COLOUR
			------------ */
			TextColor ( vat ; RGB ( 255 ; 0 ; 0 ) )
		)
)

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

Use this custom function the correct the vat input.

2 values are needed; the vat input number ( just digits ) and the country code ( short ).

To check the vat number you can use this custom function in combination with the " CheckVatBE " ( only belgian vat numbers ).

Comments

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

VatFormat ( vat ; country )

Comments

Support this website.

Support this website.