Hello,

using the ValueListItems () design function i gathered items from two valuelists into two calcfields, every item separated by a paragraph (linefeed!?) from the next in each field. One field contains quotations from a text, the other page numbers.

What i want to do is create a third (calc?)field, which combines the contents of the both fields in the way that it takes the first line of the first field, concatenates the first line of the second field, creates a new line, then takes the second line of the first field and concatenates the second line of the second field and so on.

Unfortunately i do not find a text function that simply reads the first line of a field.

thank you

It can be done, but it requires a line of calculation for each line in your two fields. Something like:

field3 (calculation, text) =

Left(field1, Position(field1, "

Thank You very much,

I was afraid that there will be no simple function...

I will try this with a looping script, because there is no restriction on the number of quotations (i.e. lines in the first two fields) ...

Michael

It may be possible to do this differently depending on where your value lists originate from. If they come from field contents, you could possibly set up some kind of calculated field to concatenate the actual field info and then create a new value list based on this calculated field to accumulate the result.

Thanks Bob,

sounds very interesting.

The value lists are conditional values from other fields by a relationship. I tried Your idea last night, but I unfortunatley got the error message that a third valuelist generated from a calc field (which uses a similar relationship than the valuelists before) won