String functions
String functions are vector functions that manipulate vectors of strings to provide information about a string or substring, concatenate and split strings, or transform strings based on specified criteria.
This section contains details about the String Functions provided in the 1010data Macro Language. These functions provide a set of tools for performing common operations on strings (text data) stored in the 1010data system.
These function descriptions are tersely written to provide a compact and concise summary of
each function's use-case, parameters, and outputs. The following list contains some
information that generally applies to the functions found in this section:
- X is the column that contains the string data that the function will act on
- Y is also a string. It is either a scalar or column that you the function uses to evaluated X against (i.e., is X the same as Y?)
- L is a list
Note: In general, String Functions allow you to compare and make simple edits and
transformations to strings contained in a database.