Rons Data Stream - Features

General Features

		Jobs Setup
		Define your data sources, formats, and destinations with ease. Jobs allow you to store associated files (when kept in a directory) or run them separately — executed with a single click or via the command line.
		Customizable Cleaners
		Create, name, save, and reuse one or more Cleaners to set up robust cleaning rules that process your data consistently across multiple Jobs.
		Flexible Rules Engine
		Combine numerous column, row, and cell operations into comprehensive cleaning workflows. (See the List of Rules section below for detailed operations).
		Multiple Data Sources and Formats
		Seamlessly load data from a variety of sources. Configure the output formats for simple file conversion—whether it’s CSV, XML, JSON, SQLite, or others. (For more details, refer to our Source and Destination Information section below.)
		Clean and Intuitive Layout
		Enjoy a streamlined Data Stream interface complete with light/dark mode and customizable theme colors for a distraction‐free workspace.
		Powerful Preview Screen
		The Preview Window displays a clear side-by-side comparison of your original data and the processed output, allowing you to fine-tune your cleaning tasks with precision.
		Comprehensive Log Files
		Automatically generate log files to help track errors and diagnose issues, especially when processing large data sets.
		Full Control Over Text Formats
		Support for all major text encodings—including UTF-7, UTF-8, UTF-16, and UTF-32 (both big and little endian)—with automatic detection ensures your data maintains integrity.

List of Cleaning rules

The (growing) list of available data operations in Rons Data Stream are shown in the table below.

• Column Processors
  • Add Column(s)
  • Update Column
  • Copy Columns
  • Move Columns
  • Delete Columns
  • Merge Columns
  • Split Columns
• Row Processor
  • Add Row
  • Delete Row
  • Split Row
• Cell Processors
  • Add Text
  • Add Random Text
  • Pad Text
  • Remove Text
  • Replace Text
  • Reverse Text
  • Add Space
  • Remove Space
  • Add Numbers
  • Remove Numbers
  • Replace Numbers
  • Add Date Time
  • Replace Date Time
  • Change Case
  • Split Name
  • HTML Encode
  • HTML Extract
  • Fill Lookup
  • Lookup Replace

Sources and Destinations

Rons Data Stream began its journey as the automation component of Rons CSV Editor, originally focused on text-based data formats. As our customers’ needs evolved, we expanded support to include a wider range of formats. Below is an overview of the currently supported sources (input) and targets (output).