Professional Web Applications Themes

Searching for doubles. - FileMaker

Hello, I'm working on a database with some 20.000 famiienames in it. Some of these persons are more then one time in the database. I would now make a list in MSWord of all the different names without having some of theme more then one time. Is there a script to do that? Can someone help me. Sorry for my english. Thanks, Eric...

  1. #1

    Default Searching for doubles.

    Hello,

    I'm working on a database with some 20.000 famiienames in it.
    Some of these persons are more then one time in the database.
    I would now make a list in MSWord of all the different names without having
    some of theme more then one time.
    Is there a script to do that?
    Can someone help me.
    Sorry for my english.

    Thanks,

    Eric

    Eric Dekeuckelaere Guest

  2. #2

    Default Re: Searching for doubles.

    In article <BBC199EA.1C53D%dekeuckelaerepandora.be>, Eric Dekeuckelaere
    <dekeuckelaerepandora.be> wrote:
    >Hello,
    >
    >I'm working on a database with some 20.000 famiienames in it.
    >Some of these persons are more then one time in the database.
    >I would now make a list in MSWord of all the different names without having
    >some of theme more then one time.
    >Is there a script to do that?
    The manual that comes with Filemaker uses a version of this problem as its
    example script. Essentially, you find duplicates, sort, then loop through
    the set, comparing the field contents to a global field that is reset
    every time around the loop. The script sets a flag field as it goes.

    The result, if you tailer the script correctly to your data, is having a
    flag field set for all but one of every duplicate record.

    Now it's a simply matter to run a find, omitting the flagged duplicates,
    then exporting the result as a text file you can open in Word.

    Steve Brown
    eyebrown@mindspring.com Guest

Similar Threads

  1. Eliminating Doubles in SQL
    By Marsbar24u in forum Dreamweaver AppDev
    Replies: 3
    Last Post: March 16th, 07:40 AM
  2. Freehand doubles prints
    By 54xmax in forum Macromedia Freehand
    Replies: 2
    Last Post: May 21st, 05:02 PM
  3. My XML import into inDesign doubles the carriage returns
    By Ben_Marchbanks@adobeforums.com in forum Adobe Indesign Windows
    Replies: 0
    Last Post: April 17th, 12:23 PM
  4. Problem with multiplying doubles
    By christine in forum PHP Development
    Replies: 4
    Last Post: November 29th, 01:59 PM
  5. win32api calling with doubles
    By ROTH Jakub in forum Ruby
    Replies: 1
    Last Post: August 11th, 10:14 AM

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