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.
Working With Lynx
API Reference
Click to Read
API Updates
- Data Cleaning:
- Added
UNIQUE(array)to easily remove duplicate values from an array. - Added
COMPACT(array)to removenull,undefined, and empty values.
- Added
- 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.
- Added
- String Formatting:
- Added
TITLE(string)to convert strings to Title Case. - Added
PAD(string, length, char)to pad strings (useful for IDs).
- Added
