Add2array
AddArray (Array,insertarray, start): Inserts all elements from the Insertarray in the first position of the array, and returns the array.
Example:
AddArray ([3, 4, 1, 5, 7], [23, 43, 22], 3) return [3, 4, 23, 43, 22, 1, 5, 7].
AddArray ([3, 4, 1, 5, 7], "Test", 3) returns [3, 4, "Test", 1, 5, 7].
Attention:
If start is less than 1 or the start parameter is not written, the array element is inserted by default from the first bit of the array
ARRAY
ARRAY (Arg1,arg2 ...): Returns a arg1,arg2,... An array of components.
ARG1,ARG2,...: string or number.
Example:
ARRAY ("hello") = ["Hello"].
ARRAY ("Hello", "world") = ["Hello", "World"].
ARRAY ("Hello", 98) = ["Hello", 98].
ARRAY (67,98) = [67,98].
Getarrayelement
Getarrayelement (Array,index): The function returns the index element of an array of arrays.
Example:
String[]array = {"A", "B", "C", "D"}
Getarrayelement (array,3) equals C.
Getarrayelement (array,1) equals A.
Greparray
Greparray (ARRAY,FN): function (returns TRUE or false) is a condition that filters this array and finally forms a new array.
Example:
Greparray ([3,4,2,3,6,8,7], "Item! = 3") equals [4,2,6,8,7]
Note: The second parameter of the function is a string.
INARRAY
INARRAY (Co,array): Returns the position of the Co in an array of arrays, or 0 if the co is not in array.
Example:
String[]arr = {"A", "B", "C", "D"}
Then inarray ("B", arr) equals 2.
INDEX
INDEX (Key,val1,val2,...): Returns key in Val1,val2,... The number of parameters returned in a sequence that does not exist in the series.
Note:
Key and Valn can be any type
Example:
INDEX (2,2) equals 1.
INDEX (2,1,2) equals 2.
INDEX (2,4,5,6) equals 4.
INDEX ("B", "B", "O", "y") equals 1.
Indexofarray
Indexofarray (Array,index): Returns the index element of an array of arrays.
Example:
Indexofarray (["First", "second", "third"], 2) returns "second".
Maparray
Maparray (ARRAY,FN): Converts an item in an array to another array.
Array: Arrays to convert
fn (function): functions that work with array items
Example:
Maparray ([3,4,2,3,6,8,7], "Item! = 3") equals [False,true,true,false,true,true,true].
RANGE
The RANGE (from,to,step) function represents an example of a sequence of steps, starting with an integer from, with step for each step: until the integer to.
Note:
The range function has three parameter types
RANGE (to), default from 1,step is 1
RANGE (from,to), the default step is 1
RANGE (From,to,step), with reference to the above comment
Example:
RANGE (4) returns [1,2,3,4].
RANGE (-5) returns [].
RANGE ( -1,3) returns [ -1,0,1,2,3].
RANGE (0,5) returns [0,1,2,3,4,5].
RANGE (6,-1,-2) returns [6,4,2,0].
RANGE (4,1,1) returns [].
Removearray
Removearray (Array,start, DeleteCount): Removes the DeleteCount array element starting from the first element of the array and returns the deleted arrays.
Example:
Removearray ([3, 4, 4, 2, 6, 7, 87], 4, 2) return [3, 4, 4, 7, 87].
Reversearray
Reversearray (Array): Returns an array of arrays in reverse.
Example:
Reversearray (["First", "second", "third"]) returns ["third", "second", "first"].
Slicearray
Slicearray (Array,start, end): Returns the array from start to end (including the end of the first element).
Example:
Slicearray ([3, 4, 4, 5, 1, 5, 7], 3, 6) return [4, 5, 1, 5].
When the end parameter is not used, returns the element from start to end of the array.
Slicearray ([3, 4, 4, 5, 1, 5, 7], 3) returns [4, 5, 1, 5, 7].
Sortarray
Sortarray (Array): An array that returns an array of arrays that are sorted in sequence.
Example:
Sortarray ([3, 4, 4, 5, 1, 5, 7]) return [1, 3, 4, 4, 5, 5, 7].
Note: The array element type must be the same and can be compared.
Uniquearray
Uniquearray (Array): Removes the repeating element from the array.
Example:
Uniquearray ([14, 2, 3, 4, 3, 2, 5, 6, 2, 7, 9, 12, 3]) return [14, 2, 3, 4, 5, 6, 7, 9, 12].
Web Reporting Tools Finereport usage Summary of common functions (array functions)