Arten Science Releases R10Clean 2 Professional - Data Cleaning Solution

[news 28]

Arten Science Releases R10Clean 2 Professional - Data Cleaning Solution - Published on 02/24/09

 

IMMEDIATE RELEASE

 

Arten Science today announced R10Clean Professional Version 2, their Cross Platform Utility designed to clean, manipulate, de-duplicate or fix large amounts of data. Data can be imported from a CSV, TAB delimited or Text file, modified and then saved back in several different formats including native Excel, TAB Delimited and Comma Separated. You can also save the modified file using your own Custom Delimiter.

 

Derbyshire, UK - Arten Science has announced R10Clean Version 2 Professional is now out of Beta and available to purchase.

 

What Is It?

A powerful tool for working with, manipulating, de-duplicating and cleaning large amounts of data.

 

Who Is It For?

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

 

Minimum Requirements:

* Mac OS X Version 10.4 or higher

* Windows XP / Vista / Window 7

* Linux with GTK+ 2.x

* Universal Binary for PowerPC and Intel

* G4 Processor, 1GHz or faster

* 20 MB Hard Drive space

 

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.

 

R10Clean 2: http://www.r10clean.com

Arten Science: http://www.artenscience.co.uk

Download R10Clean: http://www.artenscience.com/autoupdate/latestversions/r10clean_osx.zip

Screenshot: http://www.artenscience.com/images/r10clean_mac.jpg

Icon: http://www.artenscience.com/images/ico_r10clean.png

 

 

Arten Science was setup in 2007 to design, develop and market quality commercial software for the Apple Mac OSX (Universal Binary), Windows XP / Vista and Linux with GTK+ 2.x. We also provide Bespoke Software Development and Technology / Database / Security Consultancy services. In addition to creating new solutions for our customers, all of our commercial products can also be tailored, modified and enhanced to suit your specific requirements. We can help you to use software to solve business problems and create business opportunities. Arten Science are the creators of the Protect Client Data Initiative.

 

###

 

Steve Cholerton

CEO

07525754153

 

steve ( -at -) artenscience.co.uk

 

 

 

 

 

 

*******

 

*******

 

*******