Dividing text through several text fields

[iBib]

We want to create a function which would take a text in a text field and put it in several other fields depending on how many text breaks there is in the text.

Example:

When two Breaks is in a text present the function would take the text paragraph after those two breaks and put it in a new field. And continue doing that up to 10 times.

Any idea how this could be done?

[Chuck]

Do you want to keep the contents of the original field the same, or does that need to change too?

If you want to keep the contents the same, then you can use a calulation field to do the job. Calling your first field Text_Entry and calculation field Calced_Text here's the equation:

Case(

[iBib]

Thx a bunch, i'll try it as soon as I can.