create find script that searches for variable "&"

[hart]

I have a search that ask you to put in a vin# if I put in the right number then the search performs nicely.

Some of my database entries contain an "&" in their field.

When someone enters the vin# they don't normally input that "&" into their find.

So if they do a find without the "&" then the find returns a no match.

What I am asking is their someway to make the find look for the exact match and if it can't find it then do a search for the vin# containing the "&" character?

The "&" is always located as the fourth entry in the data

I.E 5GZ&Z43D

[Ender]

Try making a calc field that will be used only for finds:

Vin#_Find (calculation, text result) = vin# & & Filter(vin#; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890")

[hart]

Thanks for the tip but I have tried and tried but have been unsuccessful with using the code to get it to work.

Could someone please help?

I have attached a sample of the database.

You have to hold the shift button when opening it and when the password comes up it's Admin

thanks

data.zip

[Lee Smith]

Hi Hart,

I don't have version 7, so I can't check your attachment. However, if you just post the calculation maybe I can help.

Lee