loops in a calculation field

[barbaras]

hello there,

I've a script with a loop of this kind :

setloop = 1

loop

leftword ("test",setloop,1)

setloop = setloop + 1

end loop if setloop = #whatever..

end loop

where "setloop" is a number field.

So, Something very classical !

don't bother on the leftword commande syntax !

What I would like to do is the same kind of auto-incrementing of "setloop" in a calc field, but of course "calc field" doesn't allow this kind of recursive loop.

I've my nose on it and I cannot figure it out, how to get in the right direction.

so, thank you for your help,

[Vaughan]

The best you can do is hard-code in a set number of iterations... say, 20 or however many will exceed your expected number of words.

[-Queue-]

Or use a repeating calc, value list based on it, and a ValueListItems field. Check here for an example.

[barbaras]

Thank you guys for your help,

I pointed me in the right direction.