Out of, then into repeating field?

[blindbo]

I have a repeating field used for 5 levels of pricing. Field is set for 12 repeating, so user admin can add column pricing as needed. They want to have an export of the data to work with in Excel.

PROBLEM 1) When I export, all the repeats are into one cell (albeit seperated by a (?) bullet).

PROBLEM 2) How to get the data back into its respective repeated cell in fm5.5 (win)?

Thanks in advance.

[Kurt Knippel]

A repeating field is a hold over from the olden days of Filemaker and it does not have an equivelant data structure in any other applications, so you cannot import or export repeating fields except between Filemaker files.

You are much better off using a related file with pricing information.