Text Cleaner - Clean Up Invalid Characters

Your data list can contain irrelevant characters and double spaces. The Text Cleaner automates such tasks and wipe out all non-printing characters like line breaks, delete all digits, letters or special mathematical, currency and letter like symbols and punctuation marks.

Text Cleaner Tool Bar

It's good to clean up the list before doing a match/deduplication by removing all unwanted characters, a list of deduplication will then be much more effective.

Text Cleaner Window

Option Description
Remove Letters This option will remove all characters except numbers within the specified column.
Remove Numbers This option will remove all numbers within the specified column.
Remove Spaces This option will simply remove all spaces within the specified column.
Remove Doubles

This option will remove double spaces and characters, reducing to a single character. It can remove multiple whitespace characters and preserve a single whitespace in text.

Examples: "$$500" becomes "$500" and "West--Street " becomes "West-Street"

Remove Trailing / Leading Spaces This option will remove all spaces that come before the first character, and all spaces that follow the last character.

Example: " Falls Church, VA 22044 " becomes "Falls Church, VA 22044"

Remove Non-Printable Charactors Sometimes, when you import data into a worksheet, extra characters show up unexpectedly along with the numbers and text. Often they are in the form of squares, lines, or other oddly shaped characters, but they can also be invisible in a cell.

A quick and easy way to get rid of most of them is to use the this function it will remove all non-printing characters like line breaks, carriage return, line feed, form feed, etc.

Try Database Cleaner Now

Download Now Buy Now

Download and test on your own data!

Note: Database Cleaner never deletes any information from the source files, all information is kept temporarily in memory.