Repeating Fields

[corx]

Hi guys,

I have a file with 3 repeating fields containing 25 repetitions each.

I'd like to create a seperate file and get the data from the 3 repeating fields into 25 records.

Any suggestions will be greatly appreciated.

[aaa]

Let your repating field is A(25) B(25) C(25. Create one number global field N.

Create new file with fields AA BB CC Number. Create relation from your first file to second by N<---->Number name this relation as Rel.

Now script like this:

Set field N 1

Go to field AA

Loop

copy

past field rel::AA

go to next field

set field n n+1

exitloopif(n=26)

EndLoop

And so 3 times for field A,B,C

There may other easy ways, i posted the first way what i think.

I did it many times and each tume by different way.

[Søren Dyhr]

Make an extra table, and import into it with the splitting option chosen - no need for the recieveing table to have any repeats.

Then a comment to aaa: Exploiting copy and paste might do the trick but is unhealthy if the user should have anything important left in his/her clipboard - some objects can't even be stored temporarily in a global container or textfield! At least does your script ignore this problem???

--sd

[aaa]

Thank you very match, SOREN DYHR! I did not know about this opportunity of import!

[Søren Dyhr]

But say the solution is going to be served via IWP ...unfortunately will the import between tables not work ...or rather it's a bit dodgy - not that I've tested it, but it's so that Import is grayed out if you choose to show scriptsteps allowed for IWP, but in this case hasn't it anything to do with the users interface??? Have anyone tried ...or should I give it a stab??

--sd

[corx]

Thank you very much.

It worked like a charm.

Thanks to all who posted