Utilities
This reference manual section covers NumXL's advanced functions, including text processing with Regex, transposing rows and columns, checking for missing values in arrays, and transforming two-dimensional arrays to tabular formats, enhancing data manipulation capabilities.
- NxFold - Convert a 3 columns into a 2-D table or matrix
- NxFlatten - collapse a data table into a flat 3-columns form.
- NUMXL_INFO - Installation Information
- NxArray - Create an array using constants and/or cells references
- HASNA - Check input for observations with missing Value
- MV_OBS - Number of observations with non-missing values
- MV_VARS - Effective Number of Variables
- NxMatch - Regular Expression (regex) Match Function
- NxReplace - Regular Expression (regex) Replace Function
- NxTokenize - Separate a string by a delimiter into an array of substrings
- NxTranspose - Convert row to column (and vice versa)
- RMNA - Remove Missing Values