Editor's review
This software is able to remove/clean up data problems from the data files.
Right File Cleaner is able to fix some typical problems with text data files. For example it is able to remove duplicated and empty rows, extra spaces, non-printable symbols from values as also fix wrong capitalization and add lost spaces, etc. This is another tool, like the Right file auditor tool discussed elsewhere, that can help clean up data files received from external sources such as your B2B partners or public sources. The tool has some ten rules that help clean up file level as well as column level data in the data files. Input files supported include comma and tab separated values and custom separator separated ones. It will produce a report after a data clean up session. The files can be in HTML format. You are able to review the cleaning rules too from the project manager reports.
Optionally, the program can save duplicates to supplemental file as well as broken rows, i.e. rows that have more or less columns than required. The program is available in a console version too. Through this you would be able to schedule the cleaning sessions and run them automatically. The cleaner offers project report that lets you review the cleaning rules. The interface takes you through several settings processes and these are easily done through simple clicks of checkboxes. This is going to be a very handy tool when there are a lot of data exchanges happening in your business.
User comments