top of page

Sort Tool

This tool can sort outline numbers, e.g. 1.2.5.10, that would be out of order using a typical sort function.

Consider the this table which has a 'Structure ID' column that is not sorted properly.  

Example Table - order scrambled

When a normal sort function is used on the 'Structure ID' column, the 10's appear before the 2's.  This is because the typical sort algorithm checks  each character in each string in sequence; it doesn't recognize the integer values separated by the period.  

Example Table - Result after standard spreadsheet sort on Structure ID

When the Mainsheet BOM Tools Sort Function is used the 10's follow the 2's, as they should because this sort function recognizes the integer values separated by the period. 

Example Table - After Sorting on Structure ID with Tool - Correct Order Achieved
bottom of page