Hello

I have been trying to get a calculation or a script to automate the deciphering of a vin number. The problem is most formulas have exceptions and for example the model number might involve 2 , 3, 4, 5,6 of the 17 digit number and not always at the same starting place. If I am calling each part of the number with a V then the numbers of the VIN number are V1, V2, v3, v4,v5,v6,v7,v8,v9,v10,v11,v12,v13,v14,v15,v16,v17 . I am trying to figure out for example a way to decode this. A 2002 Dodge status has a model or v5,v6,v7 or specifically G42 but a LExus is decoded at the 4th digit v4,v5,v6,v7,v8 or BF30G for 5 digits. Some are only 2 digits long. Does anyone have any idea how to calculate the decoding of these? I am stuck and any help at all is very much appreciated.

So thanks in Advance.

If you should think of something later even

please respond at any time.

Sincerely

Dave

I am sure there are many ways to do this. But there must be an expert way.

Thanks again.

This is rather challenging.

May be by using some Relationships, calcs and mixed relationships/calcs.

Unless someone has already done this (I guess it is), you may attach a small set of the VIN numbers and what should be their counterparts, so that we could figure out what exactly the parameters and variables are.

If someone has invented a way to codified VIN, there's surely a way to decode them.

Thanks UGO,

I am not at home where I am working on this. but tonight I will try to get some of these concepts together. Thanks for your answer so far. I will get that done as soon as I get out of work.

Dave

Thanks for the Answers here are some more facts about the vin numbers.

From Auto Insurance tips website.

A car

I wanted to clarify the end of what I wrote in the last post.

It should have read like this:

THEY ARE LIMITED to the following series of numbers to find the model

(2,3)4,5,6 -------5 digit

(2,3)5,6,7------- 5 digit

(2) 5,6,7 --------4 digit

(2,3) 4,7,8 -------5 digit

(2) 4,5,6 ---------4 digit

(3)4,5,6 ----------4 digit

The official document states that:

(: the fourth to eighth characters, inclusive, shall uniquely identify the decipherable information for the vehicle as set out in column II of Table I, except that

(i) the fourth and fifth characters shall be alphabetic and the sixth and seventh characters shall be numeric for a passenger car, multipurpose passenger vehicle or truck having a gross vehicle weight rating of 4,536 kg or less, and

(ii) subject to subparagraph (i),

the characters and their positioning may be determined by the manufacturer;

So, you'll need to implement parsing of model based on manufacturer (first 3 chars)

Dj