For Companies & Schools

New Lynx Functions for Data Cleaning and Math

We've added a set of new functions to Lynx to make data manipulation easier, specifically focusing on data cleaning, match operations, and string formatting.

API Updates

  • Data Cleaning:
    • Added UNIQUE(array) to easily remove duplicate values from an array.
    • Added COMPACT(array) to remove null, undefined, and empty values.
  • Math operations:
    • Added ROUND(number) to round numbers to the nearest integer.
    • Added ABS(number) to get the absolute value.
    • Added MOD(lhs, rhs) for modulo operations.
  • String Formatting:
    • Added TITLE(string) to convert strings to Title Case.
    • Added PAD(string, length, char) to pad strings (useful for IDs).