AnsweredAssumed Answered

Unusual data lookup problem.

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

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

Outcomes