StringArray.SplitSort(String) Method

 Top 

Description

Splits each element of the calling StringArray into columns based on the delimiter specified by stringArgument, then sorts the first column in ascending order, reordering the other columns to maintain the relative positions of the array elements. Then reforms each row, using spaces to merge the columns.

 

Timing Precision Mode

This page describes functionality in millisecond timing precision mode. Millisecond timing precision mode is deprecated and will be removed in a future release. We recommend that you migrate your Mission Plans to nanosecond timing precision mode.

Click here to see the documentation for this object in nanosecond timing precision mode.

 

Method Signature

StringArray.SplitSort(

String stringArgument)

 

 

Arguments

stringArgument

Description:

Delimiter to use when splitting the StringArray.

 

 

 

Return Value

Type:

number

 

 

Returns the number of rows in the calling StringArray.

 

Syntax

myVariable1 = myStringArray1.SplitSort(myString1);

 

 

Example 1

This example demonstrates how to use the StringArray.SplitSort method to split a StringArray into columns, sort the first column (reordering the other columns to maintain the relative positions of the array elements), and then reform the rows using a space as the new delimiter.

 

// Create Objects

StringArray StringArraytoSplitSort;

String delim1;

 

// Set delimiters

delim1 = ", ";

 

StringArraytoSplitSort = {"Mary, Thomas, F",

                                 "James, Thomas, M",

                                 "Thomas, Smith, M",

                                 "James, Smith, M",

                                 "Daniel, Jones, M",

                                 "Susan, Smith, F",

                                 "David, Adams, M",

                                 "Anna, Johnson, F",

                                 "John, Brown, M",

                                 "Robert, Williams, M"};

 

// Pass inputs to SplitSort - each element of the calling StringArray will be split into columns

// based on the delimiter specified by delim1 (a comma), then sorts the first column in

// ascending order, reordering the other columns to maintain the relative positions of the

// array elements.  Then, the rows are reformed, using a space to merge the columns.

 

StringArraytoSplitSort.SplitSort(delim1);

 

// Report out the sorted StringArray

For i = 0 to StringArraytoSplitSort.Dimension-1 step 1;

 Report StringArraytoSplitSort[i];

End;

 

 

Output Report:

 

StringArrayToSplitSort

Anna Johnson F

Daniel Jones M

David Adams M

James Thomas M

James Smith M

John Brown M

Mary Thomas F

Robert Williams M

Susan Smith F

Thomas Smith M

 

 

 

 

 

See also

StringArray Object

StringArray.SplitSort

Parsing Arbitrary String Data