checks box, seperated into repeating fields

[rivet]

This is from a right brain thread that has turned into a left brain question. rightBrainThread

I want to separate check boxes into a repeating field for each item checked. The one thing about repeating fields that I still like is that when you import them, you can burst each repeat into a separate record which will solve my report problem.

So I am looking for a calc that will take a list of carriage returned items and put:

line one into repeat field one

line two into repeat field two... and so on up to ten repeats.

[BobWeaver]

You will need to create a repeating global number field gIndicies with the same number of repetitions as your repeating field, and then fill it with the numbers 1,2,3,4,5,6,7... etc.

Then use this formula for your repeating data field:

Middle(Extend(ChkBoxField), Position("

[BobWeaver]

Here is a demo file.

cBoxToRept.fp5.zip

[rivet]

perfect thanks