Professional Web Applications Themes

calculating unique letters in string - FileMaker

Question: Is it possible to calculate the unique letters in a string? for example boat got 4 unique letters, but feather got 6 unique letters from a total of 7 (2 times the 'e') .. is there a way to do that? Thanx, Patrick...

  1. #1

    Default calculating unique letters in string

    Question: Is it possible to calculate the unique letters in a string?
    for example boat got 4 unique letters, but feather got 6 unique
    letters from a total of 7 (2 times the 'e') .. is there a way to do
    that?

    Thanx,

    Patrick
    Patrick Guest

  2. #2

    Default Re: calculating unique letters in string

    Yes, probably several ways. Easiest (and possibly most awkward) would be to
    add them up individually:

    UniqueLetters (calculation, number) = (PatternCount (YourField, "a") > 0) +
    (PatternCount (YourField, "b") > 0) + (PatternCount (YourField, "c") > 0) +
    ....(PatternCount (YourField, "z") > 0)

    Another way would be to utilize repeating fields:

    Alphabet (global, text, 26 repetitions) - fill each repetition with a
    letter from "a" to "z"

    LettersUsed (calculation, number, 26 repetitions) = PatternCount (Extend
    (YourField), Alphabet) > 0

    UniqueLetters (calculation, number) = Sum (LettersUsed)

    "Patrick" <Shadow_Rulezhotmail.com> wrote in message
    news:a76rgvod04l1bvos17011bpnvkqhfpkv404ax.com...
    > Question: Is it possible to calculate the unique letters in a string?
    > for example boat got 4 unique letters, but feather got 6 unique
    > letters from a total of 7 (2 times the 'e') .. is there a way to do
    > that?
    >
    > Thanx,
    >
    > Patrick

    Glenn Schwandt Guest

  3. #3

    Default Re: calculating unique letters in string

    Ok, gonna give them a try.. .thanx....


    On Thu, 10 Jul 2003 12:20:43 -0500, "Glenn Schwandt"
    <schwandtgataoldot.com> wrote:
    >Yes, probably several ways. Easiest (and possibly most awkward) would be to
    >add them up individually:
    >
    >UniqueLetters (calculation, number) = (PatternCount (YourField, "a") > 0) +
    >(PatternCount (YourField, "b") > 0) + (PatternCount (YourField, "c") > 0) +
    >...(PatternCount (YourField, "z") > 0)
    >
    >Another way would be to utilize repeating fields:
    >
    >Alphabet (global, text, 26 repetitions) - fill each repetition with a
    >letter from "a" to "z"
    >
    >LettersUsed (calculation, number, 26 repetitions) = PatternCount (Extend
    >(YourField), Alphabet) > 0
    >
    >UniqueLetters (calculation, number) = Sum (LettersUsed)
    >
    >"Patrick" <Shadow_Rulezhotmail.com> wrote in message
    >news:a76rgvod04l1bvos17011bpnvkqhfpkv404ax.com.. .
    >> Question: Is it possible to calculate the unique letters in a string?
    >> for example boat got 4 unique letters, but feather got 6 unique
    >> letters from a total of 7 (2 times the 'e') .. is there a way to do
    >> that?
    >>
    >> Thanx,
    >>
    >> Patrick
    >
    Patrick Guest

Similar Threads

  1. Unique Form inserting into many tables using unique id
    By Gabo Navarro in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 0
    Last Post: September 16th, 06:25 PM
  2. Calculating age
    By Tom Thackrey in forum PHP Development
    Replies: 9
    Last Post: June 9th, 08:49 PM
  3. Calculating Fields
    By will_garcia@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 1
    Last Post: April 27th, 08:17 PM
  4. Calculating
    By Andreas Saarva in forum PHP Development
    Replies: 2
    Last Post: February 26th, 05:30 PM
  5. Replies: 2
    Last Post: August 6th, 08:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139