| UDF Function/Parameter | Comments |
|---|---|
| All changed functions | Values returned in @error on function error may well have changed - details on specific Help file pages. |
| _ArrayAdd | Now supports 2D arrays and can add multiple lines in one call. |
| $vValue | Altered: Value(s) to add - can be a single item, a delimited string or an array. |
| $iStart | Added: If adding data to a 2D array, the column at which the insertion starts in each row (default = 0). |
| $sDelim_Item $sDelim_Row |
Added: If data passed as a delimited string these determine the number of rows/columns to be added. |
| $iForce | Added: Changes function behaviour - either forces addtion of added data as a single item or forces datatype for added items |
| _ArrayBinarySearch | Now supports 2D arrays. |
| $iColumn | Added: 0-based index of column to search (default = 0). |
| _ArrayConcatenate | Now supports 2D array swith equal number of columns. |
| _ArrayDelete | Now support multiple deletions. |
| $vRange | Altered: Element(s) to delete - either a single index, a range string or a 1D array with a count in the [0] element |
| _ArrayDisplay | Buttons at bottom of dialog can be hidden |
| _ArrayFindAll | Now supports searching 2D arrays by row as well as by column |
| $fRow | Added: If set to True, $iSubItem determines the row and not the column in a 2D array. |
| _ArrayInsert | Now supports 2D arrays and can insert multiple lines in the same or different positions in one call. |
| $vRange | Altered: Element(s) above which the insertion is to take place - either a single index, a range string or a 1D array with a count in the [0] element |
| $vValue | Added: Value(s) to insert - can be a single item, a delimited string or an array. |
| $iStart | Added: If inserting data to a 2D array, the column at which the insertion starts in each row (default = 0). |
| $sDelim_Item $sDelim_Row |
Added: If data is passed as a delimited string these determine the number of rows/columns to be added. |
| $hDataType | Added: If $vValue is a delimited string the data is converted to a string. Assigning a datatype function (Number, HWnd, etc) forces it into that datatype |
| _ArrayMax | Now supports 2D arrays. |
| $iSubItem | Added: 0-based column to search. |
| _ArrayMaxIndex | Now supports 2D arrays. |
| $iSubItem | Added: 0-based column to search. |
| _ArrayMin | Now supports 2D arrays. |
| $iSubItem | Added: 0-based column to search. |
| _ArrayMinIndex | Now supports 2D arrays. |
| $iSubItem | Added: 0-based column to search. |
| _ArraySearch | Now supports searching 2D arrays by row as well as by column |
| $fRow | Added: If set to True, $iSubItem determines the row and not the column in a 2D array. |
| _ArraySwap | Completely rewritten to swap full or part columns/rows within a 2D array |
| $iIndex_1 $iIndex_2 |
Altered: Index of the rows/columns to swap |
| $bCol | Added: If set to True, $iIndex_1 and $iIndex_2 determine the column and not the row. |
| $iStart $iEnd |
Added: Elements within the rows/columns to swap. |
| _ArrayToClip | Now just a simple wrapper for _ArrayToString. See details of parameters for that function. |
| _ArrayToString | Now supports 2D arrays |
| $sDelim_Item $sDelim_Row |
Added: Determine the column/row delimiters. |
| $iStart_Row $iEnd_Row |
Added: Limit the rows to extract. |
| $iStart_Col $iEnd_Col |
Added: Limit the columns to extract. |
| _ArrayTranspose | Now transposes 1D arrays |
| _ArrayTrim | Now supports 2D arrays |
| $iSubItem | Added: Column to trim |
| _ArrayUnique | For consistency with all other functions $iColumn is now 0-based, not 1-based |
| New UDF Function |
Comments |
|---|---|
| _ArrayColInsert | This function is used to insert columns into 1D or 2D arrays. |
| _ArrayColDelete | This function is used to delete columns from 2D arrays. |
| _ArrayExtract | This function extracts a smaller array from inside 1D and 2D arrays. |
| _ArrayShuffle | This function uses the FisherYates algorithm to shuffle all or some of the rows of 1D and 2D arrays. The shuffle can be limited to a specific column in a 2D array. |
| Unchanged UDF Function |
|---|
| _ArrayCombinations |
| _ArrayPermute |
| _ArrayPop |
| _ArrayPush |
| _ArrayReverse |