Ron's Data Stream (formerly Ron's Data Cleanser) is a utility that permits you to automize the cleaning of data files as well as source jobs.

Ron's Data Stream is designed to update and clean a data source (for example, CSV files) through cleaner utilization, making the process more efficient. Cleaners are made up of a list of operations that can be built, saved, and applied to a data source as required. The preview window makes the comparison of the original data with the processed data very clear. Ron's Data Cleanser also includes a batch processing capability. This allows 100's of data files to be processed in seconds, making cleaning a whole directory fast and efficient.

Using Ron's Data Stream to create operating rules (the Cleaner) is simple - define the source, format, and output (the Job), combine and run.

Ron's Data Cleanser Features:

Jobs: set up of data sources, formats, and destinations

Jobs files can be stored with the data (if the data is in a directory), or separately if needed, and run at the click of a button or from the command line.
Cleaners: set up cleaning rules to process data

One or more Cleaners can be created, named, saved, and re-used with multiple Jobs as often as needed.
Rules: the list of operations to perform on the data
Numerous columns, rows, and cell operations are combined easily within the cleaner. See List of Rules below.

Loads data from multiple available sources
See Source and Destination Information below.

Outputs to multiple formats
Source and destination formats can be configured for simple file conversion. See Source and Destination Information below.

Quick Job
An alternative window for quickly setting up a cleaning Job. The Quick Job can even be saved as a full Job.

Preview Screen
Essential for building cleaning tasks. A clear comparison of the original data with the processed one.

Log files Output
Essential for finding errors on large files.

Full control over text format
Full-text encoding supported: Utf-7, Utf-8, Utf-16, and Utf-32 (both big-endian and little-endian), with automatic detection.

List of Cleaning rules
The (growing) list of available data operations in Rons Data Cleanser is shown in the table below.

Column Processors

Update Column(s)

Copy Columns

Move Columns

Delete Columns

Merge Columns

Split Columns

Row Processor

Add Row

Delete 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

Similar:

Best Drive Cleaner? CCleaner VS Wise Disk Cleaner VS PrivaZer

How to Use Storage Sense to Delete Junk Files in Windows 10 Automatically

How to Delete the Windows.old Folder from Windows 10

What Is the $SysReset Folder and Can I Delete It in Windows 10?

Version History for Ron's Data Stream:
https://www.ronsplace.ca/Products/RonsDataCleanser/History

Limitations:
Lite version shows in-app ads for other Ron's Place Apps products, advert banner at the base of the application, and the number of files that can be processed is limited to three. For $40.00 you can remove the banner, and have unlimited files processed.