FlowEngine Data Standardize & CleanInstall

Summary

Format text from a specified field by trimming whitespace, removing unwanted characters, converting case, and truncating length, saving the result to the original or a different field.

Inputs

• Text Field (required) — The field containing the text to format.
• Output Field — Field to save the formatted text to; leave empty to overwrite the original field.
• Case Conversion — Convert text to formats like lowercase, UPPERCASE, Title Case, Sentence case, snake_case, camelCase, or PascalCase.
• Trim Whitespace — Whether to remove extra spaces and trim the text.
• Remove Line Breaks — Whether to replace line breaks with spaces.
• Remove Special Characters — Whether to remove all non-alphanumeric characters except spaces.
• Remove Numbers — Whether to remove all numeric digits from the text.
• Remove Punctuation — Whether to remove punctuation marks from the text.
• Max Length — Maximum length to truncate the text to, with 0 meaning no limit.
• Truncation Indicator — Text to append when truncating (e.g., "..." or "…").
• Options — Additional options like tracking changes, continuing on failure, skipping unchanged items, case-insensitive field matching, and debug mode.

Output shape

a list of items each containing JSON with the formatted text stored in the specified output field (or overwritten original field).

Each output item includes optional _changes and _changesSummary fields when tracking changes is enabled, and an optional _debug field with detailed processing info if debug mode is enabled. Items can be skipped from output if unchanged and 'skip unchanged' is set. Field name matching respects case sensitivity based on option.