Returns the absolute value of x

Returns the cube root of x

Returns the x value rounded up to the nearest integer

ceil(x)

Alias for ceiling(x)

Returns the degree value for x

Returns the double value for Euler’s number

exp(x)

Returns the exponent value for Euler’s number

Returns x rounded down to the nearest integer

from_base(string,radix)

Returns the value of string interpreted as a base-radix number

ln(x)

Returns the natural logarithm of x

Returns the base 2 logarithm of x

log10(x)

Returns the base 10 logarithm of x

log(x,y)

Returns the base y logarithm of x

Returns the modulus (remainder) of n divided by m

pi()

Returns pi value. The result will be returned as a double value

Returns power of value ‘p’ to the x value

pow(x,p)

Alias for power(x,p)

converts the angle x in degree radians

rand()

Alias for radians()

Returns the pseudo-random value

rand(n)

Alias for random()

Returns the rounded value for x

round(x,d)

x value rounded for the ‘d’ decimal places

sign(x)

Returns the signum function of x, i.e.,

0 if the argument is 0

1 if the argument is greater than 0

-1 if the argument is less than 0

For double arguments, the function additionally returns −

NaN if the argument is NaN

1 if the argument is +Infinity

-1 if the argument is -Infinity

Returns the square root of x

Return type is archer. The result is returned as the base radix for x

Truncates the value for x

Returns the bin number of x specified bound1 and bound2 bounds and n number of buckets

Returns the bin number of x according to the bins specified by the array bins

Returns the inverse cosine value(x)

asin(x)

Returns the inverse sine value(x)

atan(x)

Returns the inverse tangent value(x)

Returns the inverse tangent value(y/x)

cos(x)

Returns the cosine value(x)

Returns the hyperbolic cosine value(x)

Returns the sine value(x)

tan(x)

Returns the tangent value(x)

tanh(x)

Returns the hyperbolic tangent value(x)

Count the number of bits

Perform bitwise AND operation for two bits, x and y

Bitwise OR operation between two bits x, y

Bitwise Not operation for bit x

XOR operation for bits x, y

Concatenate the given strings

Returns the length of the given string

Returns the lowercase format for the string

Returns the uppercase format for the given string

Left padding for the given string

Removes the leading whitespace from the string

Replaces the string value

Reverses the operation performed for the string

Right padding for the given string

Removes the trailing whitespace from the string

Splits the string on delimiter and returns an array of size at the most limit

Splits the string on delimiter and returns the field index

Returns the starting position of the substring in the string

Returns the substring for the given string

Returns the substring for the given string with the specific length

Removes the leading and trailing whitespace from the string

Returns the current date

Returns the current time

Returns the current timestamp

Returns the current timezone

Returns the current date,timestamp with the timezone

Returns the local time

Returns the local timestamp

Returns the string matched by the regular expression for the pattern

Returns the string matched by the regular expression for the pattern and the group

Returns the first substring matched by the regular expression for the pattern

Returns the first substring matched by the regular expression for the pattern and the group

Returns the string matches for the pattern. If the string is returned, the value will be true otherwise false

Replaces the instance of the string matched for the expression with the pattern

Replace the instance of the string matched for the expression with the pattern and replacement

Splits the regular expression for the given pattern

Check the value exists in a json array. If the value exists it will return true, otherwise false

Get the element for index in json array

Returns the length in json array

Returns the json structure format

Parses the string as a json

Returns the size of the value

Returns the URL’s host

Returns the URL’s path

Returns the URL’s port

Returns the URL’s protocol

Returns the URL’s query string

avg(x)

Returns average for the given value

Returns the minimum value from two values

Returns the maximum value from two values

Returns the sum of value

Returns the number of input rows

Returns the count of input values

Returns the checksum for x

Returns the arbitrary value for x

Renders a single bar using rgb low_color and high_color

Renders a single bar for the specified width

Returns the color value for the entered string

Renders value x using the specific color using ANSI color codes

Accepts boolean value b and renders a green true or a red false using ANSI color codes

rgb(red, green, blue)

Returns a color value capturing the RGB value of three component color values supplied as int parameters ranging from 0 to 255

Finds the max element in an array

Finds the min element in an array

Sorts the elements in an array

Removes the specific element from an array

Concatenates two arrays

Finds the given elements in an array. True will be returned if it is present, otherwise false

Find the position of the given element in an array

Performs an intersection between two arrays

Returns the array element position

Slices the array elements with the specific length

Returns the index of the string with the given substring

Returns the substring of the given string. You can specify the start index here

Returns the substring of the given string for the specific start index and length of the string