Jump to content

Alpha sort values in field


This topic is 7280 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7280 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.