Correct Sorting of Columns with Partial Numeric Values #9

Description

The current column sorting implementation in esctl may not correctly handle cases where column values include partial numbers. This feature request aims to enhance the sorting functionality to handle such scenarios correctly. Specifically, it should sort the columns in a natural order that considers the numeric portion within the values.

Motivation

Sorting columns with partial numeric values is essential for accurate and intuitive ordering of data. The current sorting mechanism may treat the values as plain text and result in incorrect sorting. By enhancing the sorting logic to recognize the numeric portions within the values, esctl can provide more meaningful and expected sorting results.

Additional Context

Consider a scenario where column values represent node names, such as "cluster-2-data-01" and "cluster-10-data-01". The existing sorting implementation may treat these values as plain text and sort them alphabetically, resulting in "cluster-10-data-01" coming before "cluster-2-data-01". This feature request aims to introduce a sorting algorithm that considers the numeric portion within the values, resulting in correct sorting order.

By addressing this issue, esctl can provide improved usability and a more natural sorting experience when working with columns that contain partial numeric values.