message.sortCSVByNumber

Signature: message.sortCSVByNumber(sortNodePath, descending*)

Returns: void

Sorts the CSV numerically based on the sortNodePath.

Note

This method only applies to CSV formatted messages.

Parameters

Type	Name	Description	Default
String	sortNodePath	the numeric column of the CSV to sort on
Boolean	descending*	(optional) when true sorts in descending order	false

Example

// Example: Sort CSV rows numerically by a column (name or index).

// Sample CSV message structure
message = qie.createCSVMessage(
    "Name,Age,DOB\n" +
    "Alice,30,1992-03-15\n" +
    "Bob,25,1997-08-22\n" +
    "Charlie,35,1987-11-10\n", // value
    false,                     // quote values
    '"',                       // quote char
    ",",                       // separator
    "UTF-8",                   // charset
    true                       // contains header
);

// Sort by numeric column (ascending) using column name
message.sortCSVByNumber(
    "Age" // column name
);
var firstNameAfterAsc = message.getNode("Name", 1); // "Bob"
var lastNameAfterAsc  = message.getNode("Name", 3); // "Charlie"

// Sort by numeric column (descending) using column index
message.sortCSVByNumber(
    "2",   // column index ("Age")
    true   // descending
);
var firstNameAfterDesc = message.getNode("Name", 1); // "Charlie"
var lastNameAfterDesc  = message.getNode("Name", 3); // "Bob"