Jump to content

Ribbit

Newbies
  • Posts

    3
  • Joined

  • Last visited

Ribbit's Achievements

Newbie

Newbie (1/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

0

Reputation

  1. You have the elegant solution from Brent Heddon and others, but you might want to experiment with a simple check I find useful. Where I collect an email in FileMakerPro, I also define "email provider" as "Middle(eMail_a;(Position(eMail_a;"@";1;1));25)" Sorting on this field I see typing errors, and see the range of email providers members of our user group utilize. Sometimes the simple answer allows you to appreciate the elegant.
  2. Thanks! Was confused and now see more about how FMP works. The hyphenated example still stands. It seems it might be new to FMP 7 since prior to 7, hyphenated words were counted as one.
  3. 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?
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.