On Nov 12, 2008, at 1:03 PM, Deborah Tinsley wrote:
How do I pull together the multiple artists from the portal into one
field?
1. Create a calculated field that:
. Uses the List ( ) function.
. Replaces the carriage returns with whatever delimiters you want.
Such a calculation might look like:
Let ( [
artistList = List ( relationship::_cArtistNameDateField ) ; //
Turn your portal records into a list
artistLine = Substitute ( artistList ; "ΒΆ" ; "; " ) // Replace
the pilcrow (paragraph mark) with a semicolon and a space
] ;
artistLine // Return the result
)
2. Export the calculated field of the records in question.
Also, you may just use a text field and set it with a looping script
that sets it with the same calculation.
j.
--
Jonathan Fletcher
[EMAIL PROTECTED]
Project Foreman
NewMedia Construction Co.
