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

    Unusual data lookup problem.



      Unusual data lookup problem.


      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?







      1NameJohn Smith

      2TitleProject Manager

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

      Web: www.abc.com