Jump to content

17 number text formatting


This topic is 4399 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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().

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 4399 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.