Modifiers
Modifiers are services that process and transform data at the column level.
Data Cleaning
A transformation function that allows users to clean and normalize textual data by applying basictext operations such as trimming whitespace, changing case (lowercase, uppercase, titlecase).
Date Formatter
A transformation function that converts date-like values in the selected column(s) into a standardized or custom date format, using date-fns library for date parsing and formatting.
Pseudoanonymization
Pseudoanonymize or de-anonymize data in the selected column using encryption service. Choose between encrypting original values or decrypting vault keys.
Regular Expression Modifier
A transformation function that allows users to apply regular expression operations on text data, including pattern matching, replacement, and extraction of matched values.
Common Examples:
- Extract numbers with up to 2 decimals: Pattern:
\\d\\.\\d{1,2}(without anchors) - Truncate to 2 decimals: Operation: Replace, Pattern:
^(\\d\\.\\d{2})\\d*$, Replacement:$1 - Extract email addresses: Pattern:
\\w@\\w\\.\\w - Remove special characters: Operation: Replace, Pattern:
[^a-zA-Z0-9\\s], Replacement: (empty)
Note: Use anchors (^ and $) only when you want to match the ENTIRE cell value. Without anchors, the pattern will match anywhere within the text.
Text to columns / Columns to text
A transformation function that allows joining multiple columns into one or splitting a single column into multiple columns using a separator defined by the user or by extracting the first or last portion of the cell value.
Text to rows
A transformation function that allows splitting the values of a single column into multiple rows using a custom separator defined by the user. For each split value, a new row is created and the values of the other columns are duplicated.