FlowEngine Data Standardize & Clean icon

FlowEngine Data Standardize & Clean

Clean and transform data without code - deduplicate, format phones, normalize emails, and more

Actions13

Format Text

AI-generated

Summary

Format and clean text from a specified field by applying case conversions, removing unwanted characters, trimming spaces, removing line breaks or numbers, and truncating to a max length; store the result in the original or a different output field.

Inputs

  • Text Field (required) — The field containing the text to format.
  • Output Field — Optional field name to save the formatted text. Leave empty to overwrite the original field.
  • Case Conversion — Choose a case format to convert the text to, including camelCase, lowercase, UPPERCASE, snake_case, Title Case, PascalCase, Sentence Case, or none.
  • 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.
  • Max Length — Optional maximum length to truncate the formatted text (0 means no limit).
  • Truncation Indicator — Text to append when truncating (e.g., "..." or "…").
  • Options — Additional options including case insensitive field matching, continue on fail, debug mode (adds detailed debug info in _debug field), skip unchanged items from output, and track changes (adds _changes field showing modifications).

Output shape

a list of JSON items, each representing an input item with the formatted text applied

Each output item contains the modified JSON data. If enabled, _changes field shows before/after changes, and _debug includes detailed transformation info. Items with no text changes can be skipped from output if the skipUnchanged option is set to true.

Examples

Example 1: Format the 'description' field by trimming whitespace, converting to Title Case, removing numbers and punctuation, truncating to 100 characters, and saving to 'formattedDescription' field.

Text Field='description'; Output Field='formattedDescription'; Case Conversion='title'; Trim Whitespace=true; Remove Numbers=true; Remove Punctuation=true; Max Length=100; Truncation Indicator='...'

Discussion