This operation arranges the elements of an input (e.g., words, numbers, or lines) in a specific order. It is useful for organizing data, analyzing patterns, or preparing datasets for further processing.
Data types
These are the input/output expected data types for this operation:
Input data
- Input strings to be sorted.
Output data
- Sorted data.
Parameters
These are the parameters you need to configure to use this operation (mandatory parameters are marked with a *):
Delimiter*
Choose the delimiter that separates each segment in your input data. Choose one of the following:
Line feed - Select this to have each line of text as a separate value.
Space - Your segments are separated by spaces.
Comma - Your segments are separated by commas (,)
Semi-colon - Your segments are separated by semi-colons (;)
Colon - Your segments are separated by colons (:)
CRLF - Carriage return line feed (CRLF) is a control character that originally referred to moving the carriage on typewriters back to the starting position. In computing, it’s used in classic Mac OS and some Windows-based systems to mark the end of a line. If your input uses \r as the line-ending character, you can set the delimiter to \r to correctly separate values. For example: 100\r200\r300
Order*
Choose the type of sorting to be applied. Choose one of the following:
Alphabetical (case sensitive) - Rearranges the elements in alphabetical order, considering case.
Alphabetical (case insensitive) - Rearranges the elements in alphabetical order, ignoring case.
IP address - Sorts a list of IP addresses in numerical order, rather than treating them as strings.
Numeric - Sorts values as numbers rather than strings. This ensures proper numerical order, where 2 comes before 10, unlike a lexicographic sort which might order them as 10, 2.
Numeric (hexadecimal) - Sorts hexadecimal numbers as their numeric equivalents, not as strings. For example, 0x1A (26 in decimal) will come before 0xF (15 in decimal), regardless of their string order.
Reverse
Set this parameter to true if you want to reverse the order of the sorted elements.
Example
Suppose you want to sort the terms of a series of strings in your input data:
In the Operation field, choose Sort.
Set Delimiter to Comma.
Set Order to Alphabetical (case sensitive).
Set Reverse to false.
Give your Output field a name and click Save. The terms in your input field will be sorted following the specified conditions.
For example, this text:
banana,apple,orange,grape
will be sorted as:
apple,banana,grape,orange
You can try out operations with specific values using the Input field above the operation. You can enter the value in the example above and check the result in the Output field.
In your Pipeline, open the required configuration and select the input Field.
