Logic

The following functions allow you to perform logic and evaluate values in expression bindings.

📄️ binEnc

Takes a list of booleans and treats them like the bits in a binary number.

Takes a list of booleans, and returns the index (starting at 1) of the first parameter that evaluates to true.

This function acts like the switch statement in C-like programming languages.

This function, which accepts any number of arguments, evaluates each in order, and returns the first non-null argument.

This function returns the bit value (an integer, 0 or 1) in the number at position position, according to its binary representation.

This function returns true if the given value has changed since the last time the Expression Item was run.

This function evaluates the expression condition, and returns the value of trueReturn or falseReturn depending on the boolean value of condition.

Searches for the first occurrence of the substring inside of string. Returns the index of where substring was found, or -1 if it wasn't found.

Tests to see whether or not the given value's quality is bad.

Tests to see whether or not the given value's quality is either bad or error.

Tests to see whether or not the given value's quality is either error.

Tests to see whether or not the given value is good quality.

Tests to see whether or not the argument value is null

Tests to see whether or not the given value's quality is Uncertain.

Searches for the last occurrence of the substring inside of string.

Returns the length of the argument, which may be a string or a dataset.

This looks for lookupValue in the lookupColumn of dataset.

This function acts like the switch statement in C-like programming languages.

This expression is used to swallow errors caused by other expressions.