Alpha sort values in field

[pspafford]

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

[BobWeaver]

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")]

[pspafford]

A thing of beauty, Bob.

Thanks.

Paul