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

Source: Internet
Author: User

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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.