Tutorial - How to Sort a Lightroom Keyword List
Tab-Indented List Sorting for Beginners
Here is an image showing a list of colors in the most basic of list formats, where each word is separated by carriage-return/line-feed. I am displaying this list in PSPad, and will use that program for the following examples, though most text-editors would work equally as well.
(Do you recognize the order that those colors are in? See below for the answer).
To sort the basic list above, click 'Edit > Select All', or Control + A, then click 'Edit > Sort' which will open the Sort window as shown in the next image.
There are various options available, but this time we will just choose the basic default selection, as shown. Click OK, and the list will be sorted into Alphabetical Order, as shown in the next image.
This is all very straight-forward, and easy enough to understand, but when it comes to sorting a tab-indented keyword list, such as the keyword list that is imported to or exported from Lightroom, Breeze Browser, Photo Mechanic, and other photo-processing programs, things get a bit more complicated. The next image below shows an example of the tab-indented format that these programs use and produce. (For in-depth information to the tab-indented format, see my Photo Keyword List Format page.) PSPad and many other text editors come with basic sort capabilities and can sort a simple list very well as we have seen, but if you wish to sort a range of keywords that are stored in a tab-indented hierarchical list, as is shown in the example below, we need extra tools.
So how do you sort a big list containing multiple sections in one go, and how do you sort the parent categories that contain them? The obvious answer is to sort each section separately by first selecting each section and sorting as above, then re-arranging the parents by copying from one window to another, but this is a tedious task and can take a very long time. There are commercial software packages available, usually linked to popular spreadsheets, that will sort a tab-indented list but they don't do error-checking, and they don't keep synonmys, recognised by their curly brackets, adjacent to their parent word. When I started to research the problem, I soon discovered that there was nothing specifically designed for keyword lists and the unique features they contain, so I set about writing a suitable tool of my own.
The good news is that this tool is now online, here on this website, and you are welcome to use it to sort and error-check your own tab-indented keyword lists. You can find it here: Tab Indented List-Sorting and Error-Check Tool. There is no charge to use it, but if you find it useful I'd appreciate a mention in your Blog and any online groups.
Answer to my question: Did you recognize the order that those colors were in? I would have expected any electronic engineers or radio technicians to know the answer straight away, as these colors are in the order of the Resistor Color Code