Import data from a Repetition Field?

[Anh_Tran]

I would like to export data to excel but the problem is that for the repetition. I did not see it clear and give me an confusion how to separate them. Do you have any suggestions how to export to excel with repetition field? Is it extension is mer or csv?? I tried them both but does not work at all. I would like to have your advice.

Thanks

[LaRetta]

Hi Anh_Tran!

One possibility is to establish calc fields for each rep position (unstored) and make sure they are the same field type as your Repetition field, then write your calc as:

GetRepetition(YourRepetitionField, 2) where 2 is the rep position within the field. If you want each value in the Repetition field to be an individual record, you can have each value expand using data array techniques. An excellent example can be found on CobaltSky's Website

It's called Array Expander and it's invaluable in learning about multikey fields and arrays. I hope this helps ... if not, there are many more, much wiser frequenters on this Forum that will be glad to assist!

LaRetta

[andygaunt]

You could import into a seperate database, and in the import routine, choose to seperate repeating fields into seperate records.. Then you can export from that database as a merge file (which keeps the field headings), and open that .mer file in excel, using , as the seperator and " as the text qualifier (otherwise you will have "'s around all the text)

HTH