Title
Omitting entries that contain the * character
Post
Hello there forum,
I work for a company that utilizes FileMaker Pro as their database to list items and how many of each we have sold (over 15000 entries). The problem I am having is that whoever created the database used the wildcard character before about 14,600 of the entries. The problem is that there is no way to sort which ones have the wildcard before and those that do not. I have tried using different search criteria to only bring up those without the character but have been unsucessful. I was wondering if there is some way to do a search and only bring up wildcards. basically being able to search the * as a character and not an wildcard.
Any help would be great.
-Morgan
put the asterisk in quotes:
"*"
will find any record with an asterisk as the first letter
*"*"*
Will find any record where this field contains an asterisk anywhere within the field.