Web Reporting Tools Finereport usage Summary of common functions (array functions)

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)