The principle behind the data cleansing methodology is that it allows the user to delete unwanted rows from a data base without re-ordering the the database as a whole.

The first column of the worksheet is deemed to be the 'Cleaning Column'. If necessary, insert a new column at 'A' to act as the source for cleaning the database.

In the example shown below the 'Data' is an extract from the ACBA (UK) LTD website log, but for various reasons we have visited our own site and this corrupts the usage date. We want to clean the database of our own activity.

In this case we have used the 'Clean Col' to extract the first 4 characters of the WebLog and call the Clean Database User Form to delete all the rows where column 'A' has the value 'acba'.

You can repeat the process for different values as many times as required.

In our example, the revised data base now has all reference to 'acba' in column A removed.

Remarks

For more details about ACBA Analytical and Audit Tools our website contains general descriptions and additional information about it.

See also

Audit Tools Menu