AnsweredAssumed Answered

Unusual data lookup problem.

Question asked by NJHomeowner on Apr 21, 2010
Latest reply on Apr 21, 2010 by (O_O)


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: