Functions for managing arrays

These functions allow you to easily handle the Array, Associative Array and Dynamic Array variables:



Add

Adds an element in last position:

of a one-dimensional WLanguage array.

of an advanced array property (array of events of gglCalendar, etc.).

from a WLanguage list.

AddColumn

Adds a column at the end of a two-dimensional array property (xlsDocument variable for example]).

AddLine

Adds a row at the end:

of a one- or two-dimensional WLanguage array.

of a two-dimensional array property of a variable type (xlsDocument variable for example).

AddReference

Adds the reference of an object at the last position in a one-dimensional array.

 

Apply

Executes a procedure for each element of a WLanguage array.

ArrayAdd

Adds an element in last position:

of a one-dimensional WLanguage array.

of an advanced array property (array of events of gglCalendar, etc.).

of a WLanguage list.

ArrayAddLine

Adds a row at the end:

of a one- or two-dimensional WLanguage array.

of an advanced two-dimensional array property (xlsDocument, etc.).

ArrayAddReference

Adds the reference of an object at the last position in a one-dimensional array.

ArrayAddSorted

Adds an element to a one-dimensional WLanguage array taking into account the sort criterion defined by ArraySort.

ArrayCopy

Copies the content of an array into another array.

ArrayCount

Returns:

the number of elements found in a one-dimensional array.

the number of rows found in a two-dimensional array.

the number of elements found in the first dimension of a three-dimensional or N-dimensional array.

ArrayDelete

Deletes an element at a given position:

from a one-dimensional WLanguage array.

from an advanced array property (array of gglCalendar events, etc.).

from an associative array.

from a WLanguage list.

ArrayDeleteAll

Deletes all elements:

from a one-dimensional or two-dimensional WLanguage array.

from an associative array.

from an advanced array property (array of gglCalendar events, etc.).

from a WLanguage queue.

from a WLanguage stack.

from a WLanguage list.

ArrayDeleteDuplicate

Deletes the duplicates from an array.

ArrayDeleteLine

Deletes a row at a given position:

from a two-dimensional array.

from the advanced array property (array of gglCalendar events, etc.)

The array size is automatically reduced.

ArrayInfo

Returns the characteristics of an array: type of elements, number of dimensions, dimensions, etc.

ArrayInsert

Inserts an element at a given position:

into a one-dimensional array.

into an associative array.

into an advanced array property (array of gglCalendar events, etc.).

into a WLanguage list.

ArrayInsertLine

Inserts a row at a given position:

into a two-dimensional WLanguage array.

into an advanced two-dimensional array property (xlsDocument, etc.).

ArrayInsertReference

Adds the reference of an object at given position in a one-dimensional array.

ArrayMove

Allows you to:

move an element in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, etc.). The other array elements are moved accordingly.

swap two elements in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, etc.).

ArrayMoveLine

Allows you to:

move a row in a two-dimensional array or in an advanced array property. The other array rows are moved accordingly.

swap two rows in a two-dimensional array or in an advanced array property.

ArrayReverse

Reverses the content of a one-dimensional array.

ArraySeek

Seeks the subscript of an element in a WLanguage array.

ArraySeekByProcedure

Seeks an element in a one-dimensional WLanguage array by using a comparison procedure.

ArrayShuffle

Shuffles the elements of a WLanguage array.

ArraySort

Sorts a WLanguage array.

ArraySwapLine

Used to swap two rows in a two-dimensional array or in an advanced array property.

ArrayToCSV

Converts a one-dimensional array or a two-dimensional array into a character string in CSV format.

ArrayToString

Converts a one-dimensional array or a two-dimensional array into a character string.

 

CheckAllFalse

Returns True if all the elements of an array are False.

 

CheckAllTrue

Returns True if all the elements of an array are True.

 

CheckAnyFalse

Returns True if at least one element of an array is False.

 

CheckAnyTrue

Returns True if at least one element of an array is True.

CSVToArray

Fills a one- or two-dimensional array of the specified type with the character string in CSV format passed in parameter.

Delete

Deletes an element at a given position:

from a one-dimensional WLanguage array.

from an advanced array property (array of gglCalendar events, etc.).

from an associative array.

from a WLanguage list.

DeleteAll

Deletes all the elements:

from a one-dimensional or two-dimensional WLanguage array.

from an associative array.

from an advanced array property (array of gglCalendar events, etc.).

from a WLanguage queue.

from a WLanguage stack.

from a WLanguage list.

DeleteColumn

Deletes a column at a given position from the advanced array property (array of gglCalendar events, etc.).

DeleteLine

Deletes a line at a given position:

from a two-dimensional array.

from the advanced array property (array of gglCalendar events, etc.).

FileToArray

Fills an array of classes or structures with the content of a HFSQL data file or query.

Filter

Returns an array containing the elements of a source array for which a procedure returns True.

Insert

Inserts an element at a given position:

into a one-dimensional WLanguage array.

into an associative array.

into an advanced array property (array of gglCalendar events, etc.).

into a WLanguage list.

InsertColumn

Inserts a column at a given position into an advanced two-dimensional array property (xlsDocument, ...).

InsertLine

Inserts a row at a given position:

into a two-dimensional WLanguage array.

into an advanced two-dimensional array property (xlsDocument, etc.).

InsertReference

Adds the reference of an object at given position in a one-dimensional array.

Map

Executes a procedure on each element of a source array and returns the results in a WLanguage array.

Move

Allows you to:

move an element in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, etc.). The other array elements are moved accordingly.

swap two elements in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, etc.).

MoveColumn

Moves or swaps a column in a two-dimensional array property of advanced type (xlsDocument, ...).

MoveLine

Allows you to:

move a row in a two-dimensional WLanguage array or in an advanced array property. The other array rows are moved accordingly.

swap two rows in a two-dimensional WLanguage array or in an advanced array property.

Reduce

Applies a computation to each element of a WLanguage array.

Seek

Seeks the subscript of an element in a WLanguage array.

SeekByProcedure

Seeks an element in a one-dimensional array by using a comparison procedure.

Sort

Sorts a WLanguage array.

StringToArray

Fills a one- or two-dimensional array of the specified type with the character string passed in parameter.

SwapLine

Used to swap two rows in a two-dimensional array or in an advanced array property.

Other functions also available for the arrays:



Mean

Calculates the mean of several elements:

elements found in an array,

numeric values, ...

Sum

Calculates the sum of the array elements.

Remark: To reset all the array elements to their initial value, use VariableReset.