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
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
