Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008
    Posts
    6

    Red face Unanswered: comparing different sets of data

    Hi

    I am running an online marketing campaign. I am a mac user.

    I need to turn the following 2 text documents:

    1.Contacted people

    Lula-Vampiro,nh-last,elenith,Minocula,ey1000high,MissingLight,molo ni,sullivantpaul,devil_lynx

    2.New people

    mickeymouse,Lula-Vampiro,ey1000high,donaldduck,devil_lynx

    into the following text document

    3.New people I haven't contacted
    mickeymouse,donaldduck

    Please note that some of the names will have hyphens and underscores. My list 1 will eventually number over 50,0000 with list 2 numbering about 1000

    Is there a way to import lists 1 and 2 into filemaker and export list 3?
    Is filemaker the best way to accomplish this?

    Many thanks.

    I have posted this query elsewhere and other users suggested filemaker.

  2. #2
    Join Date
    Apr 2008
    Location
    Dallas, Texas
    Posts
    22
    Well, it should be easy to do as long as both sets of data have the same fields. You'll have to know what the field and record separators are. If it is just one field per record, then that is easy too. You can do it all in FileMaker, but it is probably easier just to open it in a Text Editor (or word processor) and make sure all the separators are good. My recommendation is to make sure that fields are separated by tabs and records are separated by carrier returns. Just do a find/replace. Then you'll be ready to import into a FileMaker table. Simply import that first data and then the second data and it will all reside in the new FileMaker table and ready for your use.

Posting Permissions

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