SQL-like query language for csv

Numeric Functions

name description
ABS Return the absolute value of a number
ACOS Return the arc cosine of a number
ACOSH Return the inverse hyperbolic cosine of a number
ASIN Return the arc sine of a number
ASINH Return the inverse hyperbolic sine of a number
ATAN Return the arc tangent of a number
ATAN2 Return the arc tangent of two numbers
ATANH Return the inverse hyperbolic tangent of a number
CBRT Return the cube root of a number
CEIL Round a number up
COS Return the cosine of a number
COSH Return the hyperbolic cosine of a number
EXP Return the value of base e raised to the power of a number
EXP2 Return the value of base 2 raised to the power of a number
EXPM1 Return the value of base e rised to the power of a number minus 1
FLOOR Round a number down
IS_INF Return whether number is an infinity
IS_NAN Return whether number is a NaN
LOG Return the natural logarithm of a number
LOG10 Return the decimal logarithm of a number
LOG1P Return the natural logarithm of 1 plus a number
LOG2 Return the binary logarithm of a number
LOGB Return the binary exponent of a number
POW Returns the value of a number raised to the power of another number
ROUND Round a number
SIN Return the sine of a number
SINH Return the hyperbolic sine of a number
SQRT Return the square root of a number
TAN Return the tangent of a number
TANH Return the hyperbolic tangent of a number
BIN_TO_DEC Convert a string representing a binary number to an integer
OCT_TO_DEC Convert a string representing a octal number to an integer
HEX_TO_DEC Convert a string representing a hexadecimal number to an integer
ENOTATION_TO_DEC Convert a string representing a number with exponential notation to an integer or a float
BIN Convert an integer to a string representing the bynary number
OCT Convert an integer to a string representing the octal number
HEX Convert an integer to a string representing the hexadecimal number
ENOTATION Convert a float to a string representing the number with exponential notation
NUMBER_FORMAT Convert a number to a string representing the number with separators
RAND Return a pseudo-random number

e is the base of natural logarithms

Definitions

ABS

ABS(number)
number
float
return
float

Returns the absolute value of number

ACOS

ACOS(number)
number
float
return
float

Returns the arc cosine of number.

ACOSH

ACOSH(number)
number
float
return
float

Returns the inverse hyperbolic cosine of number.

ASIN

ASIN(number)
number
float
return
float

Returns the arc sine of number.

ASINH

ASINH(number)
number
float
return
float

Returns the inverse hyperbolic sine of number.

ATAN

ATAN(number)
number
float
return
float

Returns the arc tangent of number.

ATAN2

ATAN2(number2, number1)
number2
float
number1
float
return
float

Returns the arc tangent of number2 / number1, using the signs of the two to determine the quadrant of the returns value.

ATANH

ATANH(number)
number
float
return
float

Returns the inverse hyperbolic tangent of number.

CBRT

CBRT(number)
number
float
return
float

Returns the cube root of number.

CEIL

CEIL(number)
number
float
return
float

Rounds number up to an integer value.

CEIL(number, place)
number
float
place
integer
return
float

Rounds number up to place decimal place. If place is a negative number, place represents the place in the integer part.

COS

COS(number)
number
float
return
float

Returns the cosine of number.

COSH

COSH(number)
number
float
return
float

Returns the hyperbolic cosine of number.

EXP

EXP(number)
number
float
return
float

Returns the value of base e raised to the power of number.

EXP2

EXP2(number)
number
float
return
float

Returns the value of base 2 raised to the power of number.

EXPM1

EXPM1(number)
number
float
return
float

Returns the value of base e rised to the power of number minus 1.

FLOOR

FLOOR(number)
number
float
return
float

Rounds number down to an integer value.

FLOOR(number, place)
number
float
place
integer
return
float

Rounds number down to place decimal place. If place is a negative number, place represents the place in the integer part.

IS_INF

IS_INF(number [, sign])
number
float
sign
integer

The default is 0.

return
ternary

Returns whether number is an infinity. If sign is greater than 0, then returns whether number is a positive infinity. If sign is less than 0, then returns whether number is a negative infinity. If sign is 0, then returns whether number is either infinity.

IS_NAN

IS_NAN(number)
number
float
return
ternary

Returns whether number is a NaN.

LOG

LOG(number)
number
float
return
float

Returns the natural logarithm of number.

LOG10

LOG10(number)
number
float
return
float

Returns the decimal logarithm of number.

LOG1P

LOG1P(number)
number
float
return
float

Returns the natural logarithm of 1 plus number.

LOG2

LOG2(number)
number
float
return
float

Returns the binary logarithm of number.

LOGB

LOGB(number)
number
float
return
float

Returns the binary exponent of number.

POW

POW(base, exponent)
base
float
exponent
float
return
float

Returns the value of base raised to the power of exponent.

ROUND

ROUND(number)
number
float
return
float

Rounds number to an integer value.

ROUND(number, place)
number
float
place
integer
return
float

Rounds number to place decimal place. If place is a negative number, place represents the place in the integer part.

SIN

SIN(number)
number
float
return
float

Returns the sine of number.

SINH

SINH(number)
number
float
return
float

Returns the hyperbolic sine of number.

SQRT

SQRT(number)
number
float
return
float

Returns the square root of number.

TAN

TAN(number)
number
float
return
float

Returns the tangent of number.

TANH

TANH(number)
number
float
return
float

Returns the hyperbolic tangent of number.

BIN_TO_DEC

BIN_TO_DEC(bin)
bin
string
return
integer

Converts bin representing a binary number to an integer.

OCT_TO_DEC

OCT_TO_DEC(oct)
oct
string
return
integer

Converts hex representing a octal number to an integer.

HEX_TO_DEC

HEX_TO_DEC(hex)
hex
string
return
integer

Converts hex representing a hexadecimal number to an integer.

ENOTATION_TO_DEC

ENOTATION_TO_DEC(enotation)
enotation
string
return
float

Converts enotation representing a number with exponential notation to a float.

BIN

BIN(integer)
integer
integer
return
string

Converts integer to a string representing the binary number.

OCT

OCT(integer)
integer
integer
return
string

Converts integer to a string representing the octal number.

HEX

HEX(integer)
integer
integer
return
string

Converts integer to a string representing the hexadecimal number.

ENOTATION

ENOTATION(float)
float
float
return
string

Converts float to a string representing the number with exponential notation.

NUMBER_FORMAT

NUMBER_FORMAT(number [, precision, decimalPoint, thousandsSeparator, decimalSeparator])
number
float or integer
precision
integer

The default is -1. -1 is the special precision to determine the number of digits automatically.

decimalPoint
string

The default is “.”.

thousandsSeparator
string

The default is “,”.

decimalSeparator
string

The default is empty string.

return
string

Converts number to a string representing the number with separators.

RAND

RAND()
return
float

Returns a random float greater than or equal to 0.0 and less than 1.0.

RAND(min, max)
min
integer
max
integer
return
integer

Returns a random integer between min and max.