2 Replies Latest reply on Apr 21, 2010 12:20 PM by (O_O)

    Unusual data lookup problem.

    NJHomeowner

      Title

      Unusual data lookup problem.

      Post

      I have a set of data in excel that has a very peculiar format as shown below:

       

      There are close to 5,000 iterations of the data like this all seperated by a space between each iteration.

      I want to export the data into filemaker as a flat file.  I think the best way to do it would to export it to filemaker and then do a  lookup of each iteration of "Name", then "Title", etc.  The first iteration would go into record # 1, the 2nd iteration into record #2, etc. Unfortunatley I don't know how to make lookup return the 2nd, 3rd, 4th, etc match - only the first exact match.

       

      Any suggestions?

       

       

       

       

       

       

       ABCD
      1NameJohn Smith


      2TitleProject Manager


      3CompanyABC IncPhone: 123-4567
      4Address1123 Main StreetFax: 123-4567
      5Address2Anywhere, USAEmail: anybody@abc.com



      Web: www.abc.com