Choose Currency:
Menu

Tab-Delimited List Sorting and Error-Check Tool

Input List (editable)

Tooltip Answer Sort Input List
Performs error check before and after sorting.
(Click for full explanation in new page)
Tooltip Answer Clear All
Clear Input and Output Lists.
(Click for full explanation)
Tooltip Answer Copy Output List to Input List
Useful for multiple stages of processing.
(Click for full explanation)
Tooltip Answer Fix Category Positions
Lock current category positions before sorting.
(Click for full explanation)
Tooltip Answer Un-Fix Category Positions
Remove locked category-positions before sorting.
(Click for full explanation)
Tooltip Answer Load a Test List with No Errors
This list demonstrates the sorting capabilities.
(Click for full explanation)
Tooltip Answer Load a Test List with Included Errors
This list demonstrates how errors are caught and reported.
(Click for full explanation)
Tooltip Answer Load a Test List with Multiple Categories
This list is used to demonstrate the 'Fix Category Positions' facility.
(Click for full explanation)
Tooltip Answer Transliterate Foreign Characters
Swap foreign characters to equivalent safe ASCII ones.
(Click for full explanation)
Tooltip Answer Capitalise all text in Square Brackets
Capitalise all Category text.
(Click for full explanation)
Tooltip Answer Delete all Square Brackets
Remove all square brackets from Categories.
(Click for full explanation)
Tooltip Answer Delete Duplicate Lines
Delete all duplicate lines from the Output List, but not the Input List. Can also be used to merge two or more lists.
(Click for full explanation)
Tooltip Answer Delete all Curly Brackets
Delete all brackets from Synonyms and sort as normal.
(Click for full explanation)
Tooltip Answer Delete all Trailing TABs
Delete all TAB characters found after the text on each line.
(Click for full explanation)
Tooltip Answer Delete all Illegal Characters
Remove all characters not allowed in keyword lists ,;<>|?
(Click for full explanation)

Input Lines:   Output Lines:   Duplicate Lines:   Illegal Characters:
Errors Found:   Bracket Counters   [   ]   {   }

Output List (non-editable)
[car]
	{automobile}
	{motorcar}
	Chevrolet
	Pontiac
	Riley
	Rolls Royce
		Phantom
		Silver Cloud
		Silver Ghost
[fruit]
	apple
		Golden Delicious
			cooker
			desert
		Granny Smith
			cooker
			desert
	banana
	durian
	mango
religion
	Christian
		Catholic
		Protestant
tools
[vegetable]
	carrot
	celery
	pea
	potato
		Golden Wonder
			processed
			un-processed
		King Edwards
		Marris Piper

 

Instructions
This webpage provides access to an online tool which performs a number of useful tasks on a TAB-delimited list of keywords that has been pasted into the 'Input List' box.

It starts with a two-stage error-check to locate the following common tab-indented list errors:

  • Illegal characters ,;<>|?
  • Missing or extra Square or Curly Brackets
  • Excess TAB characters
  • Blank Lines
  • Trailing TAB characters
  • Duplicate Lines
  • Non-ASCII characters
Any errors discovered should be corrected before proceeding. There are various tools provided to help you.

It will then perform a case-insensitive sort on the error-free list and display the sorted list in the 'Sorted List' box. Synonyms in curly brackets are kept next to their parent word.

Additional tools are provided for common list-processing tasks.

Important Notes
This tool will NOT work if the entire list has been indented with a column of extra TABs (i.e. if the first line has one or more leading TABs). Please remove these before using the Tab-Delimited List Sorting Tool. An easy way to do this is described on the Tab-Indented List Tutorial page.

You can't type a Tab-character into the Input List, but you can copy and paste one from somewhere else.

Please be PATIENT when processing large lists, and give the tool a chance to complete its work.

The 'Delete Duplicate Lines' tool will only remove the errors from the 'Sorted List' box, but NOT from the 'Input List' box. These errors will re-appear if more processing is done. An alternative is to click 'Copy Sorted List to Input List' which will copy the error-free output into the 'Input List' area.

If no list has been pasted into the 'Input List' box, an error-free test list is displayed. There is also a test list with a range of errors, that is useful to check error-trapping, and a multiple-category list to show how the 'Fix Category Positions' and 'Un-Fix Category Positions' tools operate. Click 'Clear All' to clear the lists.

If you would like to see what the sorted list will look like when it is loaded into your image processor, Digital Asset Management program or image library, see the Tab-Delimited List Visualization Tool.

For further information, please see the Tab-Delimited List Sorting and Error-Check Tool Help Page.

If you find the Tab-Delimited List Sorting Tool useful I'd appreciate a mention in your Blog and any online groups.

Web design and photography by photo-keywords.com   ::   All images and pages on this site are © 2005 - 2017   ::   All rights reserved
Flag Counter