Text Cleaning

Support

How does Text Cleaning work?
In most Text Cleaning applications you are presented with two fields. The left field (red) is the Source field. The right field (green) is the Destination field.
  1. Type or paste the list of text items you want to convert in the left Source field.
  2. Choose the Text Cleaning Type.
  3. Click the OK button to Clean all occurrences from the list of items.
  4. Click the Clipboard button to place the Destination text onto the clipboard ready to paste wherever you want.
SortItOut006
Note that
  • The Destination field is read-only.
  • Text Cleaning tries to take into account accented and foreign characters, but there may be problems with certain languages in certain text cleaning (such as Butchers Talk).
What Text Cleaning Type options are there?
In most Text Cleaning applications you can click on the Options button in the toolbar. You will be presented with a new window with a popup menu showing the text cleaning types. As you choose these, the list of options may change below. There is also a Description tab explaining what this text cleaning type does, and there is an Example tab showing some sample text and what it looks like when converted.

SortItOut002SortItOut003
SortItOut004
How do I get Help with my Text Cleaning application?
In most Text Cleaning applications you can click on the Help button in the toolbar. You will be presented with a screen of help text on how to use the program. If you need further help then please use the
Contact page.
SortItOut001
How does Data Cleansing work?
Before you can clean your database text, you must first log into the MySQL database. Enter the values suitable for your database. If you want to make changes, ensure your login account has write-access.

DataCleansing001

Choose the:
  1. Database table you want to clean, ensuring the Primary key field is correct.
  2. Choose the field that you want to be changed.
  3. If the text cleaning is to be based on a different field, then check the Based on checkbox and choose that field.
  4. If you only want to affect a subset of the records, then check the Where checkbox and enter the filter information in the WHERE field (not including the WHERE command itself!)
  5. Choose the text cleaning type form the popup menu and set any available options.
  6. Click then Preview button. Note that this will not change any data.
CleaningType1

The list will populate with any matching records and three columns: the Primary key, the Current field value and the Cleaned field value.
If the cleaned field is unchanged from the current field value then the words '«Unchanged»' appear in the Cleaned column — this is to distinguish it from a cleaned field that results in a blank or empty value.
You may perform additional text cleaning previews or export the results to CSV, tab-delimited or XML format.
If you wish to update the fields then click the Update button. Note that this will update the records in the database and it cannot be undone.
CleanCity

Note that also:
  • Multi-field Primary keys are not supported
  • You can highlight then remove any records from being updated.
  • You can copy all three fields (Primary Key, Current Value and Cleaned Value) or just the Cleaned Values to the clipboard.
  • You can save the displayed values as an Excel file (in XML format), as a comma-separated-value (CSV) file or as a tab-delimited (TXT) file.
  • Many of the Cleansing types have optional parameters. If one is available the Options window will appear automatically.
  • You can view the Wikipedia entry on Data Cleansing from within the application.
  • You can set the font size of the Cleaned Text display list.
  • Your database settings are stored for each launch. Open the Preferences window to change to a new database.