Jump to content

Proper use of the * character?


Earl Squirrel
 Share

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

Recommended Posts

Folks

How do I find OXF1-30-D-G1, OXF2-42-D-G1, etc, in a list that includes some 20,000 different variations of OXFsomethingGsomething? I have tried OXF*G1, but it doesn't work. What am I doing wrong? I used to be able to perform this find in earlier versions of the program, but I know FM changed somethings in 7.

8.5 Advanced

Link to comment
Share on other sites

I don't know the why but I can get it to work by searching for

OXF * G1

and putting spaces before and after the *

I hope this is a file issue because I have done reporting before using a similar technique.

EDIT:

I suspected it had something to do with the hyphens and by removing the hyphens the search worked as expected. I even tried replacing the hyphens with underscores and it still did not work.

Edited by Guest
Did some Research
Link to comment
Share on other sites

The search will still be indexed. FileMaker has two indexes on text fields, individual words, and values (up to a newline). The value index will be used here on the prefix, and the end part will be scanned. With a mere 20K records, this appears instant to me.

This technique has the advantage of being more like what was being used pre-7.0, to minimize the work Earth Squirrel needs to do to change this over. Also, searching for G1 as a word like you suggest is going to find "G13", "G14", etc, which I assume was not desired.

Link to comment
Share on other sites

I will instuct our people to place a space after or before the asterisk.

The asterisk is not required - it's the space that makes the difference.

With a mere 20K records, this appears instant to me.

I tried it with the provided file, and I see a noticeable lag.

Also, searching for G1 as a word like you suggest is going to find "G13", "G14", etc, which I assume was not desired.

Easily fixed by:

OXF =G1

Link to comment
Share on other sites

This topic is 5707 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.