17 number text formatting

[ttmail]

I am creating a database for cars. I need a script or function that allows me to shown the following when I input the data:

I input: 3VWFE21C04M000001

Then it outputs 3VW FE21C 0 4 M 000001

The VIN number is always 17 characters.

Also, the I, O and Q are not to be used anywhere in the VIN so I need somekind of error to shown if these are inputted.

The last five digits of the VIN should only be numeric.

Position 10 cannot be U or Z

If someone can help me with a script for this that would be great as I am OK with the basics of filemaker.

Thanks in advance.

[Lee Smith]

I am creating a database for cars. I need a script or function that allows me to shown the following when I input the data:

I input: 3VWFE21C04M000001

Then it outputs 3VW FE21C 0 4 M 000001

The VIN number is always 17 characters.

Also, the I, O and Q are not to be used anywhere in the VIN so I need somekind of error to shown if these are inputted.

The last five digits of the VIN should only be numeric.

Position 10 cannot be U or Z

If someone can help me with a script for this that would be great as I am OK with the basics of filemaker.

Thanks in advance.

Do a search of the Forum, and you should find what you need.

See the Search with the Gear next to it?

Click on it.,

Enter this search of words

+Vehicle +Identification +number Use the pluses as you see them.

Click on the Word

"FORUM"

and then

"Search Now"

You should get 7 hits.

HTH

Lee

[ttmail]

Thanks for the reply Lee but I just need to clarify......

I just really need to know how to:

1. when I enter the 17 digit VIN say 3VWFE21C04M000001

Then it outputs 3VW FE21C 0 4 M 000001

2.

An ERROR shows if the letters "I", "O" or "Q" are inputted.

3. Position 10 of the VIN must always be a letter except for years 2001-2009.

So an ERROR shows if this is not the case.

4. The last 5 digits must be numeric

Hope this clarifies my post.

[comment]

I am OK with the basics of filemaker.

Are you OK with the basic Text functions? Because that's what you need here.

1. Use the Left(), Middle() and Right() functions to parse out the entry and insert a space in-between, e.g.

Left ( VIN ; 3 ) & " " & Middle ( VIN ; 4 ; 5 ) & " " & ...

Use this formula as auto-entered calculation, replacing existing value. To make sure there are no spaces to begin with (such as when editing existing value), use the TrimAll() function before inserting the spaces.

2, 3 & 4 are matters of validation by calculation. For 2, use

IsEmpty ( Filter ( VIN ; "IOQ" ) )

3 is not clear - I don't see a year anywhere.

For 4, use Right() and Filter().

[Lee Smith]

1. when I enter the 17 digit VIN say 3VWFE21C04M000001

Then it outputs 3VW FE21C 0 4 M 000001

2.

An ERROR shows if the letters "I", "O" or "Q" are inputted.

3. Position 10 of the VIN must always be a letter except for years 2001-2009.

So an ERROR shows if this is not the case.

4. The last 5 digits must be numeric

There is a sample file I attached to one of the posts (albiet a version 5 which can be converted) that has a lot in it if I recall. Did you download it?

Lee