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).
Description | Source | Target |
---|---|---|
File Storage | Files can be read directly from a local disk or Azure Blob storage. | Files can be written directly to a local disk or Azure Blob storage. |
Note: Azure Blob Storage does not support random access so some output formats cannot be used with it.
|
||
CSV File | Separators configured per file (wild card match). | Separators configurable. |
Token File | Tokens (more than one character) configured per file (wild card match). | Tokens configurable. |
Text Template | N/A |
Generate any textual representation of the source data. For example turn a CSV file into an SQL Insert statement.
Note: Not supported in Azure Blob Storage.
|
SQL Server | Available | Source mapped to existing table or created if missing. |
SQLite | If requested. |
Available.
Note: Not supported in Azure Blob Storage.
|
HTML | Table source available. | Table output available. |
XML | Available. | Available. |
JSON | Available. | Available. |
Related Information
CSV Editing
Rons Data Stream
Application
Examples