Sort My List


DiRT (Digital Research Tools) has a new home! Please visit Bamboo DiRT to explore this excellent collection of research tools.

Web site: Sort My List

Date of first review/ name of reviewer: 7/15/08 [Tom Carlson]

Additional reviewer(s):

Produced by: 

Cost: Free

Description: Sort My List is a free online utility that allows the user a variety of powerful text processing, text sorting, and item labeling functions.

Platform: Web-based

License:

Maturity:

.

 

Sorting Functions

 

Alphabetization

 

A-Z

This is a normal alphabetize.  If numbers are present, they are sorted above the letters, in numerical order.

 

A-Z Names

This function alphabetizes by last name.  It looks for the word 'and' or '&' and breaks the string apart, so it is possible to ignore guests that might be tacked to the end of a name. For example

would be split at the & so that the entry is fitted into the list based on the 'Smith'

 

A-Z Addresses

This function requires that the addresses have a blank line between them.  Addresses may be as many lines as needed.  All of the address is ignored for the alphabetization, except for the first line.  The first line is alphabetized, according to the algorithm used for the A-Z Names sort method.

 

A-Z Titles

This function does a normal alphabetization, with the following exception.  Certain words are ignored.  The list of words that are ignored are as follows.  A, AN, THE, LA, LE, L', Il

 

A-Z Email

This function looks to the right of the '@' in a list of email addresses, and alphabetizes based upon that.  This has the effect of grouping all addresses from a company or college together.   When more than a single address from a company or college is present, the addresses are alphabetized by username.

 

A-Z HREF

This function looks to the right of the '>' in a list of href tags, and alphabetizes based upon that.  This has the effect of alphabetizing the links as the user sees them, regardless of the URL they point to.

 

Numeric Sorts

 

0-99

This function ignores most alpha characters in a string, and instead, looks at the numeric characters. If those numeric characters have a "K", "M", "G", or "m" appended to the end of them, it is assumed to be a x1000, x1000000, x1000000000, or x0.001 multiplier, and the list is sorted accordingly.

 

Time Sorts

 

Day of Week

This function searches through the item text, looking for the english language names for the days of the week.  It also searches for the common abreviations for those names, such as Mon, Tue, Wed.  Items are ordered based upon the day of the week included within their text.

 

Month

This function searches through the item text, looking for the english language names for the months of the year.  It also searches for the common abrevations for those names, such as Jan, Feb, Mar.  Items are ordered based upon the month of the year included within their text.

 

Item Manipulation

 

Mirror Items

This function mirrors the text of each item in the list.  Oprah becomes harpO, Dennis becomes sinneD

 

Reverse Items

This function reverses the word order of each word in the list items.  Oprah Winfrey becomes Winfrey Oprah, Dennis Miller becomes Miller Dennis

 

Other Sort Functions

 

Reverse List

This function reverses the item order of the list.  This is frequently used in conjunction with another sort.  So, for example, if it was desired to put a list in order from Z to A, a normal alphabetize sort would be run, and then the Reverse List sort would finish the job.

 

Random

This function randomizes the order of the items in a list.

 

Length

This function sorts the items of a list by the length of the item.  Shortest items to longest items.

 

Transpose List

This function converts rows to columns.  The user doesn't have the ability to select the seperator character between sub items within each item.  The program will break the items into subitems when it sees the following. semicolons, commas, tabs, hyphens, and spaces.

 

It is quite important that a symetrical array is created, before Transpose List is run, or the transformation may be garbled.

 

Labeling

 

Dynamic Labels

Numbers

Numbers can be added to each item, either at the beginning of the item, or at the end of the item. 

 

Letters

Letters can be added to each item, either at the beginning of the item, or at the end of the item.

 

Static Labels

Users can select a constant label that is prepended or appended to each item in the list.