Mac OS X | Business / Productivity | Spreadsheet | R10Clean

R10Clean - 1.9.7

Remove leading and trailing data from spreadsheets.

Download v 2.2.8

(File Size: 9.1M)

Free Product Alerts!

All Time:	(5.0)
Version 1.9.7:	(5.0)
Selected Version:	1.9.7
Release Date:	2009-02-15
License:	Beta
Downloads (version 1.9.7):	109
Downloads (all versions):	2,036
Price:	$30.00

Information Related to Version:

Broken Link? Newer Version? Tell us!

Product Description:

R10Clean is a Cross Platform Utility designed to make it straightforward to "clean" large amounts of data. Data can be imported from a CSV or TAB delimited file, modified (any column, any row) and then saved back in several different formats including native Excel (XLS), TAB Delimited and Comma Separated. You can also save the modified file using your own Custom Delimiter.

R10Clean supports the following Actions: Remove / Replace / Find / Insert and Format. Within each Action R10Clean provides Tasks that you can apply to the data grid. Tasks include:

Remove Leading Spaces
Remove Trailing Spaces
Remove Leading and Trailing Spaces
Remove Text
Remove Selected Row(s)
Remove Text from Start of Column
Remove Text from End of Column
Remove Text Before ...
Remove Text After ...
Remove Blank Rows
Replace Text
Find Text
Insert at the Beginning of the Column
Insert at the End of the Column
Insert Blank Row
Format as Uppercase
Format as Lowercase
Format as Capitalised

What's new in this version:

Support has been added for several popular string encodings including:
- MacRoman
- UTF8
- UTF16
- MacCentralEurRoman
- Windows ANSI
- ASCII
A "Task Scope" information label has been added to each task.
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
New Task: Count Occurrences

Operating System Requirements:

This product is designed to run on the following operating systems:

Mac OS X 10.5 Intel
Mac OS X 10.5 PPC

Feedback Summary:

Version 1.9.7:
Overall Rating:	(5.0)	Features:	(5.0)	Support:	(5.0)
Ease of Use:	(5.0)	Quality / Stability:	(5.0)	Price:	(5.0)

Key to Types of Feedback:

Reviews Reviews Troubleshooting Usage Tips Developer Notes Commentary Featured Reviews

Sanity Saver - Version: 1.9.7, 2/15/2009 12:43PM PST

ecodoc

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.