Stop Lists?

[Kurt Knippel]

quote:

---

Originally posted by steen:

Is there a way in Filemaker to create a list of stop-words that are not indexed by the system? I'd like the system to ignore A, AN and THE, so that lists generated by Filemaker do not alphabetize by initial articles. Any ideas?

---

You cannot do this exactly. What you can do is to create a calculation (stored) or a text field that is populated with the results of a calculation, which is then used for sorting purposes.

Here is a calc that will strip out the "stop-words":

SortField = Substitute ( Substitute ( Substitute ( TextField, "StopWord1", " " ), "StopWord2", " " ), "StopWord3", " " )

Then use use this field for all of your sorting.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[steen]

Is there a way in Filemaker to create a list of stop-words that are not indexed by the system? I'd like the system to ignore A, AN and THE, so that lists generated by Filemaker do not alphabetize by initial articles. Any ideas?

Thanks,

Steen