joining repetitions

[mortee]

Hi,

I have a repeating text field, and I'd like to use the concatenation of the repetitions as a single string (maybe with a given separator string inserted between the values, but this is less important).

Any suggestions? I counldn't figure it out, without having to loop through the repetitions in a script and collecting the value in a variable.

[mr_vodka]

First I would recommend not using repetitions if possible. You limit yourself with repeating fields. Related records is a much better way to go.

That being said, if you need to use repeating fields then try something like this.

Substitute ( List ( YourRepeatingField); ¶; "|" )

where the "|" is a pipe in this case but you can use a ~ or ^ or something.