Column Cleaner - Quickly find and correct discrepancies within your lists

Column Cleaner - Quickly find and correct discrepancies within your lists

The Column Cleaner module is for quickly finding and correcting  discrepancies within your list/s. By simply choosing the incorrect values from your list, then deciding on the new value, it will quickly and effectively correct all the values in  the required column.

For example: Lets say you have a list of town names in your list. You notice that there are three different spellings for the town 'Bracknell', of which only one of them is correct. This module will allow you to change the incorrect values into the correct value within seconds. All what is required is to select the incorrect values from the
list, then enter the new value, then simply click 'Convert'.

Lets use the example above in this quick 6-step guide into using the Column Cleaner Module:

Step 1: After importing your list, click the 'Clean' button, as shown below.

case1

Step 2: Click the 'Column Cleaner' Tab, as shown below:

column2

Step 3: Select the column name that you wish to modify. In this example we are using the 'Town' field. Once selected, it will then place all the distinct values from this field into the ALL VALUES box, together with a count for each value. If you look carefully, you will notice that one of the towns ("Bracknell') has 3 different spellings. Lets quickly correct this.

column3

Step 4: By highlighting the incorrect value and then clicking the [ > ], this will place
the value into the 'SELECTED VALUES' list - as shown below:

column4

Step 5: Highlight the correct value, and then click the [ > ] to place into the 'NEW
VALUE' box, as show below.

column5

Step 6: Finally click the 'Convert' button. This will then convert all the selected values
into the new value. As you can see below, the wrong spellings of the town 'Bracknell' have all been converted to the correct value, and the count is now showing 3.

column6

This kind of example can be applied for any column values (not just town names). Persons names, addresses, telephone numbers. postcodes, email addresses, etc could all benefit from using this great module to ensure your list is accurate and professional looking.