How to use the Text Sorter.
Choose numeric or alphabetical sorting explicitly. Text ordering can place 10 before 2 even when that is not the intended numerical order.
Make the workflow fit your task.
Choose numeric, lexical or a defined natural ordering, and specify ascending or descending order. Decide how headers, blanks and mixed values should be treated. Keep associated fields together when sorting records rather than isolated lines.
- What you provide
- List and sorting rules.
- What you get
- Deterministically sorted lines with numeric or alphabetical ordering.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Values: 10, 2, 1; sort numerically ascending.
Completed example
1, 2, 10.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Why does alphabetical sorting place 10 before 2?
Lexical ordering compares characters. Use numeric sorting when the values represent numbers and define how invalid numeric entries are handled.
Why did names become detached from their email addresses?
Only one column may have been sorted. Treat complete records as the sortable unit when fields belong together.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑