Other Characters - This will remove any specific characters within the selected column/s.


The following Matrix Design will remove the following:

#  characters within Address

- characters within City

_ characters within ContactName



You can also select more than one character to be removed on the same column, as shown below:



When you select these options, you will instantly see the removal of these characters on the Data Preview window.


Once you have created the Matrix for your dataset, you can then run the entire cleaning process by clicking the Run Clean button.