Unusual data lookup problem.
I have a set of data in excel that has a very peculiar format as shown below:
|3||Company||ABC Inc||Phone: ||123-4567|
|4||Address1||123 Main Street||Fax: ||123-4567|
|5||Address2||Anywhere, USA||Email: ||email@example.com|
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.