Example sorting alphanumeric column names for a query object created out of order (for example: cfspreadsheet).

queryColumnSort.cfm

<cfscript>
  // Column name example: col_1, col_10, col_6, etc.

  var qryColumnOrder = myQuery.columnList
    .listToArray()
    .sort((a, b) => {
      // Extract the numeric part from the string
      var numA = numberFormat(a.reReplace("\D", "", "all"), "0000");
      var numB = numberFormat(b.reReplace("\D", "", "all"), "0000");
      // Extract the text part from the string
      var textA = a.reReplace("\d", "", "all");
      var textB = b.reReplace("\d", "", "all");
      // First compare the text part
      if (textA < textB) return -1;
      if (textA > textB) return 1;
      // If text parts are the same, compare the numeric part
      return numA - numB;
    });
</cfscript>