Content Comparison

Addition (+)

To add two numbers or variables

Subtraction (-)

To subtract one number or variable from another

Multiplication (*)

To multiply two numbers or variables

Division (/)

To divide one number or variable by another

Modulo (%)

To find the remainder of the division of one number by another

Equal to (==)

To check if two values are equal

Not equal to (!=)

To check if two values are not equal

Greater than (>)

To check if one value is greater than another

Less than (<)

To check if one value is less than another

Greater than or equal to (>=)

To check if one value is greater than or equal to another

Less than or equal to (<=)

To check if one value is less than or equal to another

AND (&&)

To check if both conditions are true

OR (||)

To check if at least one condition is true

NOT (!)

To invert the truth value of a condition

SUM(array[])

To find the sum of a list of numbers

AVG(array[])

To find the average of a list of numbers

MIN(array[])

To find the minimum value in a list of numbers

MAX(array[])

To find the maximum value in a list of numbers

concat(string1, string2, …string)

To concatenate multiple strings into one

replace(original, regex, replacement)

To replace parts of a string

split(string, delimiter)

To split a string into an array based on a delimiter

join(array, delimiter)

To join an array of strings into a single string with a delimiter

match(string, regex)

To match a string against a regular expression

map(array, mapOperation)

To map elements of an array to another array

reduce(array, reduceOperation)

To reduce an array to another value

filter(array, filterOperation)

To filter elements from an array

length(array)

To get the length of an array

contains(array, value)

To check if an array contains a specific value

indexof(array, value)

To get the index of a value in an array

if(condition, true_value, false_value)

To return a value based on a condition

case(expression, value1, result1, value2, result, …, else_result)

To return a value based on multiple conditions

median(array[])

To find the median of a list of numbers

stddev(array[])

to calculate the standard deviation of a list of numbers

variance(array[])

To calculate the variance of a list of numbers

percentile(array[])

To find the percentile of a list of numbers