Newbies Ribbit Posted January 22, 2005 Newbies Share Posted January 22, 2005 Ray Novitske called my attention to this odd search result. In FileMaker Pro 7, finding items in a field holding 2 words beginning with the same letter yields unusual results. Consider a concantenated field (Firstname & " " & Lastname). A search for "Dan D", yields "Daniel Davis" and "Daniel Steen". Search for "D Davis", yields "Daniel Davis" and "Rusty Davis". N script will call for deleting a record after such a vague, short-cut find. However, if you are making up nonsense words for some elaborate navigation scheme, the rule should be AVOID ANY WORDS USING THE SAME FIRST LETTER. Where 2 words starting with the same letter, or hyphenation as in "cha-c", searching for "cha-c", yields "cha-c", "chan", "cha l" and "cha cha". Such a find could throw off the navigation. To find any "Mc" in a customer concantenated name field, search for "Mc m". Yields "Mc Ride", "McDerm", etc. "M mc" and "mc" get the same result. However, if you search for "R mc", yield is only those names with First name beginning with "R" and Last name beginning with "Mc" (ie, "Robert McGrew"). To find customers whose first OR last name begins with "R", search for "R R". "R" gets the same result including "Robert Roberts" and "Robert Martin". Howdver, searching for "R m" finds only those with First name beginning with "R" and Last name beginning with "M". Any repetition of the first letter after a space yields a larger find than 2 different letters separated by a space. If both search letters are the same, or both search strings begin with the same letter, and the strings exist in any of the words in the field, it will be found. "Ro Ro" finds all instances of "ro". "Ro B" finds only "Rob.. B...". ROBERT ROBERTS CANNOT BE ISOLATED BY ANY SHORTCUT SEARCH. (same for Marjie Mayer). "Ma Ma" finds any person with either a First name or Last name starting with "Ma". "Mar Mar" eliminates any "mad", etc, names but includes in the find "Mary Martin" (as one would expect) as well as Marjie Mayer which does not strictly match the search. Is there a deliberate cause for this odd result? Link to comment Share on other sites More sharing options...
This topic is 6636 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
Already have an account? Sign in here.Sign In Now