Rons Data Cleanser is a powerful tool for automatically cleaning, converting and processing one or many data sources.
Or for smaller jobs simply use "Quick Job" for single files or folders.
The Data Cleanser is designed to update and clean a data source (for example CSV files) through the use of Cleaners, replacing hours of manual editing.
Cleaners are made up of a list of operations that can be build, 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.
With the batch processing capability, 100's of data files can be processed in seconds, making cleaning a whole directory an easy task!
|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 of 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 column, row 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.|
|An alternative window for quickly setting up a cleaning Job. The Quick Job can even be saved as a full Job.|
|Essential for building cleaning tasks. 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.|
The (growing) list of available data operations in Rons Data Cleanser are shown in the table below.
Rons Data Cleanser started life as the automation arm of Rons CSV Editor, and as such currently supports text based data formats. It soon became clear that our customers needed support for more data formats, the status of which is indicated in the table below.
|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.|
|SQL Server||If requested.||Source mapped to existing table or created if missing.|
|HTML||Table source available.||Table output available.|
Why not give it a try? The download is free and the installation simple.