Hey kids.

I'm looking for something like a Set Field script step to use to sort a return delimited list that is contained in one field.

Example: I have a field called ListOfInvolvedEmployees that a script keeps adding names to. Each name is separated by a return, looking like this

Andy Nonymous

Noah Boddie

John Dough

I would like the script to make the list look like this

Andy Nonymous

John Dough

Noah Boddie

or sort by last name, but I'm sure that this is easier.

I know that I could create a separate file viewed through a portal, but I want to be able to index the field for possible relationships.

The list could have anywhere from one to twelve names in it.

Thanks.

Paul

ValueListItems trick to the rescue again.

Set up a self-relationship based on a unique field (such as serial number). Then create a value list based on this relationship using values from ListOfInvolvedEmployees.

Then, you can use this Set Field step:

Set Field [ListOfInvolvedEmployees , ValuelistItems("myFileName", "MyValueListName")]

A thing of beauty, Bob.

Thanks.

Paul