Non Printable - This will remove any non-printable characters that occur within the selected column/s.

Non-printable characters are parts of a character set that do not represent a written symbol or part of the text within a document or code, but rather are there in the context of signal and control in character encoding. Non-printable characters are used to indicate certain formatting actions, such as: White spaces (considered an invisible graphic), Carriage returns, Tabs, Line breaks, Page breaks and Null characters.


The following Matrix Design will remove all non printable characters from State & ContactName:



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.