R10Clean Data Cleaning Tool Updated
This is a maintenance release only.

Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Data Cleaning Tool Update 2.3.0
This is a maintenance release and is recommended for all customers.

Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Discount Promotion Today Only
Although the promotion is based at Windows users your license covers both the Mac and Linux versions as well.
Have you ever loaded a big-time important spreadsheet into Excel only to find that it's a complete and total mess?
R10Clean lets you clean, fix, and manipulate structured or unstructured spreadsheet data. With one magical click of your mouse, you can remove things such as leading spaces, trailing spaces, text, blank rows, and more!
Another click, and you can quickly find duplicates or specific text strings. You can Insert padding globally throughout the file and even use R10Clean to change the format case of multiple cells, or to reformat them as hexadecimal, octal, or binary!
With R10Clean, you'll be able to work with any CSV file, tab-delimited file, or text file, and you'll be able to save your cleaned-up work product as XLS, TAB, CSV, CDL, or TXT file.
The size of the files that R10Clean can handle is limited only by your system's memory, but if you're concerned, you should know that R10Clean will handle hundreds of thousands of rows and sixty columns of data without breaking a sweat!

Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
Software Updates
The products that have been updated are:
macVCR - Updated to 2.5.1
MonitorMyMac - Updated to 1.2.3
R10BatchMail - Updated to 1.5.6
R10Clean - Updated to 2.2.5
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Reviewed by The Kleper Report
Excerpts Reprinted with permission from The Kleper Report on Digital Publishing <http://www.printerport.com/kdp>, copyright 2009, Graphic Dimensions, Lauderdale by the Sea, FL.
‘Digital Publishers, and others, will find the program extremely useful when there is a need to clean and modify large data files.’
‘With the use of a series of actions the user can quickly process a large number of changes that would otherwise be time-consuming and mentally burdensome using manual means’
The Kleper Report is subscription only and can be purchased here: http://www.printerport.com/kdp

Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Data Cleaning Tools - Update 2.2.4
This release gives an additional ‘Format’ option - in which Email Addresses can now be validated.

Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Lite Released
R10Clean Lite is the same program as the full edition but features a restriction of 10000 rows only. It is priced at £20, compared to the full edition at £50.
There is no seperate download, the differentiation is made with your license key.
R10Clean Lite is available now - Version 2.0.2. Another edition to 2.0.2 is the ability to save only the selected rows of your grid. This is done by selecting the SRO checkbox.
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean 2.0.1 Update
R10Clean now defaults to the standard system default encoding.
You can now specify in the preferences the character used for CSV files. Some countries use the ; character as a delimited instead of the comma character.
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean v2 Professional Released Today
This is a free upgrade to existing users. Please email us for a new license key.
WHAT IS IT
A powerful tool for working with, manipulating and cleaning large amounts of data.
WHO IS IT FOR
For anyone frustrated with Excel who needs to clean, fix, de-dupliccate or generally manipulate structured or unstructured data.
Download a fully functional trial version, non time restricted, for Windows, Mac OSX or Linux. The Trial Version is limited to manipulating 50 rows of data.

Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Final Beta Available for Download
www.artenscience.com/autoupdate/latestversions/r10cleanbeta.zip
This will be the final Beta and the version that gets released, with the exception of some speed optimisations.
All feedback welcome.



Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Beta 1.9.9 Available for Download
www.artenscience.com/autoupdate/latestversions/r10cleanbeta.zip
This is a considerable update. The new features since the last Beta are as follows:
New encoding available, ISOLatin1 and the default encoding is now UTF8.
New task to convert to Octal.
New task to convert to Binary.
New ‘iTunes Style’ Interface. See Image Below:

New task to Transpose the Rows and Columns. To go from this:

to this:

R10Clean Version 2 Pro is getting ready to be released soon, so to buy R10Clean at the existing price and to get a free upgrade to Version 2 Pro be sure to do so this week, as there will be a significant price increase for V2 Pro when released.
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Beta 1.9.8 Available for Download
www.artenscience.com/autoupdate/latestversions/r10cleanbeta.zip
The new features since the last Beta are as follows:
A new task have been added that will reverse the text in the selected rows / columns.
A new task has been added that will convert the contents of a row / column(s) to hexadecimal.
A new task has been added that will remove control characters from the selected rows / columns.
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean 1.9.71
R10Clean can now read and write standard ASCII text files, with any and all delimiters ignored. In this mode R10Clean effectively functions as a ‘text processor’ with advanced string manipulation functions.

Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Version 2 Pro New Features Summary
R10Clean Version 2 Pro New Features
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
Excellent R10Clean Review on Version Tracker
http://www.versiontracker.com/dyn/moreinfo/macosx/10908056
I’m going to repeat the contents here anyway, because - well just *because*
‘R10Clean goes from strength to strength.
If you are engaged in audit or preliminary research of medical, biological, psychological, social, nursing or paramedical data, especially with yes, no, may-be type responses (and other types of nominal data), do yourself a favour and try this software.
It is simple but very powerful.
Before your tear your hair out on excel, SPSS and the like, you may find that the analysis is much easier after using R10Clean.
The developer is very resonsive to user feedback.
The recent addition of count occurrances can eliminate at one stroke the need to struggle with VCount and CountIF (or similar) in Excel or to have to do this manually.’

Now that’s a *great* review. Cheers
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Beta 1.9.7 Available for Download
www.artenscience.com/autoupdate/latestversions/r10cleanbeta.zip
This is a considerable update. The new features since the last Beta are as follows:
Support has been added for several popular string encodings including:
- MacRoman
- UTF8
- UTF16
- MacCentralEurRoman
- Windows ANSI
- ASCII

New Task: Remove Punctuation from End of Column ? ! . ; : ,
New Task: Find Empty Strings
New Task: Pad Left / Align Right
New Task: Pad Right / Align Left
New Task: Pad Both / Align Centre
For string padding you can specify your preferred character within the Preferences. Usually you will be padding with a space character, I should imagine, but who knows ?
New Task: Count Occurences
This particular task was suggested by one of my early users, know only as VG! This task will count the occurences of a particular numeric or alphanumeric value within the selected rows / columns. I am told this is important in several areas of science and research.
Please let me have your feedback on this new version.
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Beta 1.9.6 Available for Download
www.artenscience.com/autoupdate/latestversions/r10cleanbeta.zip
This version has the following enhancements:
All tasks are now threaded and show a progress bar and a row counter.

Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Beta 1.9.55 Available for Download
www.artenscience.com/autoupdate/latestversions/r10cleanbeta.zip
This version has the following enhancements:
Progress Bar and Counter X of XXX when checking for duplicates.
The duplicate finding code is now multi threaded to allow the UI to function and update during these processes.
I intend to make each of the ‘tasks’ multi threaded with appropriate counters and progress bar before release of Version 2. The finding of duplicates works well - but is currently relatively slow when dealing with tens of thousands of rows. I will be looking at this also before the release of Version 2.
Version 2 will have an increase in price. Some of the new features I have in mind (and have not yet discussed publicly) push the product more towards a corporate purchase which means the price has to be increased in order to appear as a creditable product. This has the effect of increasing my revenue and also helping fund further development of the product. However all licensed users of Version 1 will get a free upgrade to Version 2 when it is released in a couple of weeks or so.
I will also be creating a new website for R10Clean, the domain name is setup and ready to roll
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Beta 1.9.5 Available
www.artenscience.com/autoupdate/latestversions/r10cleanbeta.zip
This release has the following enhancements:
2.0.0 12/02/09 New ‘Options’ Dropdown Menu
2.0.0 12/02/09 Activate Horizontal Scrollbar option
2.0.0 12/02/09 Fit to Grid option
2.0.0 12/02/09 Find Duplicates by Specific Columns(s)
Any problems, let me know.
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean Beta 1.9.4 Available
www.artenscience.com/autoupdate/latestversions/r10cleanbeta.zip
The only change in this version is the addition of ‘Zero Effort Corporate Licensing’. Effectively this allows you to create a text file with your license details embedded and distribute this around your corporation with the application. The text file will be read at program startup and the software automatically licensed on that computer.
For this to work the file must be named: R10Clean_License.ini and be placed in the R10Clean folder with the application.
The contents of the file must look like this, obviously using your own license details instead
Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean V2 Public Beta
Beta 1.9.3 can be downloaded here: www.artenscience.com/autoupdate/latestversions/r10cleanbeta.zip
So far the changes that have been made to this version over the current release are as follows:
08/02/09 Slight Alteration to the Licensing Window
08/02/09 Multiple Save Buttons replaced with Radio Buttons
10/02/09 The first Grid Column is now a Row Number
11/02/09 Show Duplicates Task Added
Version 2 will mainly be focusing on adding new tasks and functionality. So far the only additional task is the ‘Show Duplicates’ task. This has been asked for several times. Once you have executed this task, if you wish to delete the selected duplicates you can use the ‘Remove Selected Rows’ task. Feedback on this new feature is welcomed.

Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed
R10Clean (Formerly DataClean) Version 2 Public Beta
If you would like to be part of the beta program, please contact betatester@artenscience.co.uk

Steven Cholerton
Arten Science
Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed



