TransKeyVIN ( value )

Transliteration key: values for VIN decoding

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:

"E"
"F"

Sample output:

5
6

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

/*
*Function Name: TransKeyVIN ( value )
*
*Transliteration key: values for vin decoding ( ISO 3779 )
*
*Created 03/18/2019 by Omelyan Burtnyk
*
*Source: https://en.wikipedia.org/wiki/Vehicle_identification_number
*/
Let([ 
	~value = value;
	~x = Case( 
		~value = "1"; 1;
		~value = "2"; 2;
		~value = "3"; 3;
		~value = "4"; 4;
		~value = "5"; 5;
		~value = "6"; 6;
		~value = "7"; 7;
		~value = "8"; 8;
		~value = "9"; 9;
		~value = "0"; 0;
		~value = "A"; 1; 
		~value = "B"; 2;
		~value = "C"; 3; 
		~value = "D"; 4;	
		~value = "E"; 5; 
		~value = "F"; 6;
		~value = "G"; 7; 
		~value = "B"; 2;
		~value = "H"; 8;	
		~value = "J"; 1; 
		~value = "K"; 2;
		~value = "L"; 3; 
		~value = "M"; 4;	
		~value = "N"; 5; 
		~value = "P"; 7;
		~value = "R"; 9; 
		~value = "S"; 2;
		~value = "T"; 3; 
		~value = "U"; 4;	
		~value = "V"; 5; 
		~value = "W"; 6;
		~value = "X"; 7; 
		~value = "Y"; 2;
		~value = "Z"; 8; 
		)
	];
	~x
	)

For the function "isValidVIN ( VIN )" to check vehicle VIN code

Comments

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

TransKeyVIN ( value )

Comments

Support this website.

Support this website.