Input_VIN_Validation ( VIN )

Vehicle Identification Number (VIN), input validation.

Be the first to rate this function Log in to vote

Omelyan Burtnyk - Show more from this author
Go To Logistics
https://gotologistics.net

Sample input:

1VWBT7Q

Sample output:

1VWBT7

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

/*
Input_VIN_Validation ( VIN )
Vehicle Identification Number (VIN), input validation.
Created 12/17/19 by Omelyan Burtnyk
*/
Let([ 
	~vin = Upper( TextFormatRemove( VIN ));

	~vin1_9 = Left( ~vin; 9 ); 
	~vin10 = Middle( ~vin; 10; 1 ); 
	~vin11 = Middle( ~vin; 11; 1 ); 
	~vin12_17 = Middle( ~vin; 12; 6 ); 

	~f1_9 = "0123456789WERTYUPASDFGHJKLZXCVBNM"; 
	~f10 = "123456789WERTYPASDFGHJKLXCVBNM"; 
	~f12 = "1234567890";

	~ch1 = Left( Filter( ~vin1_9; ~f1_9 ); 1 ); 
	~ch2 = Middle( Filter( ~vin1_9; ~f1_9 ); 2; 1 ); 
	~ch3 = Middle( Filter( ~vin1_9; ~f1_9 ); 3; 1 ); 
	~ch4 = Middle( Filter( ~vin1_9; ~f1_9 ); 4; 1 );
	~ch5 = Middle( Filter( ~vin1_9; ~f1_9 ); 5; 1 );
	~ch6 = Middle( Filter( ~vin1_9; ~f1_9 ); 6; 1 );
	~ch7 = Middle( Filter( ~vin1_9; ~f1_9 ); 7; 1 );
	~ch8 = Middle( Filter( ~vin1_9; ~f1_9 ); 8; 1 ); 
	~ch9 = Middle( Filter( ~vin1_9; ~f1_9 ); 9; 1 ); 
	~ch10 = Filter( ~vin10; ~f10 );
	~ch11 = Filter( ~vin11; ~f1_9 ); 
	~ch12 = Middle( Filter( ~vin12_17; ~f12 ); 1; 1 ); 
	~ch13 = Middle( Filter( ~vin12_17; ~f12 ); 2; 1 ); 
	~ch14 = Middle( Filter( ~vin12_17; ~f12 ); 3; 1 ); 
	~ch15 = Middle( Filter( ~vin12_17; ~f12 ); 4; 1 ); 
	~ch16 = Middle( Filter( ~vin12_17; ~f12 ); 5; 1 ); 
	~ch17 = Middle( Filter( ~vin12_17; ~f12 ); 6; 1 ); 

	~result = ~ch1&~ch2&~ch3&~ch4&~ch5&~ch6&~ch7&~ch8&~ch9&~ch10&~ch11&~ch12&~ch13&~ch14&~ch15&~ch16&~ch17
	]; 
	~result 
)

Does NOT allow to enter the wrong character
The letter "Q" is invalid on Sample Output:

Сhecks the VIN by the standard algorithm
Correct for North America
Validation rules: https://en.wikipedia.org/wiki/Vehicle_identification_number

Comments

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

Input_VIN_Validation ( VIN )

Comments

Support this website.

Support this website.