Arten Science Releases R10Clean 2 Professional

Arten Science has announced R10Clean Version 2 Professional is now out of Beta and available to purchase.R10Clean is a powerful tool for working with, manipulating, de-duplicating and cleaning large amounts of data.

If you are working with databases then unless you are a programmer it is usually far easier to extract the data and work with it in the familiar column / row format when the data needs to be checked and / or cleaned.

If working in Marketing and buying in lists for mail-merge purposes, R10Clean gives you the facilities you need to make the data clean and consistent, before you put it into your database.


An IT Systems Integrator may be responsible for transferring data from a legacy system to a newer more modern solution. R10Clean will be invaluable for tidying up those export files.

Data Controllers, Report Writers, IT Departments, DBA's - anyone who has to deal with data on a regular basis.

R10Clean can open the following kinds of files:
* Tab Delimited
* Comma Separated
* Text

R10Clean can save in the following formats:
* Excel (XLS)
* Tab Delimited
* Comma Separated
* Text
* Custom Delimited


R10Clean supports the following Actions:
* Remove
* Replace
* Find
* Insert
* Format

Each Action has several associated Tasks. Generally speaking each task will manipulate the data for the selected rows and either the selected column, or all columns. There are some exceptions however. As you select each Task the scope of the Task is shown on the lower right hand side of the screen.

Some of the included Tasks are detailed below:

Action: Remove
Task: Remove Leading and Trailing Spaces
This task is applied to selected rows only, and either a single selected column or all columns. This task will look for and remove and leading or trailing spaces. Data from third party sources can often be plagued by hidden spaces.

Action: Replace
Task: Replace Text
This task is applied to selected rows only, and either a single selected column or all columns. This task will do a Find and Replace on your the grid.

Action: Find
Task: Find Duplicate Rows - Specific Columns
This task is applied to all rows only, and selected columns. This task will search for and highlight the rows that are duplicates, based on the specific columns you have selected.

Action: Find
Task: Count Occurences
This task is applied to selected rows only, and either a single selected column or all columns. This task will search for and count the occurrences of a specific numeric or alphanumeric value. Often used for analysing data for scientific or research purposes.

Action: Insert
Task: Insert Left Padding, Align Right
This task is applied to selected rows only, and a specific column. This task will pad out the contents of the selected column to the character width you specify. The character that will be used for padding is setup within the Preferences screen. Usually you will be using a space character for padding.

Action: Format
Task: Format as Title Case
This task is applied to selected rows only, and either a single selected column or all columns. This Task will convert the text from, for example: STEVE cholerton to Steve Cholerton. This is extremely useful for tidying up data prior to importing into a database.

Action: Format
Task: Transpose Columns / Rows
This task is applied to all rows / all columns only. This task takes the rows and converts them to columns and vice versa.

Documentation, Help and Support:
* R10Clean comes with a 15 page manual in PDF format
* The Help system can be accessed from the Help button on the Toolbar
* Email support can be accessed from the Support button on the Toolbar

Pricing And Availability:
R10Clean v2 Professional is available now. Pricing is £50 for a Single User, £25 for Education and Students and £250 for a Corporate Site License. R10Clean v3 Pro is a free upgrade for users of Version 1. Please contact us for a new license key.


Read More