Remove non-printable characters from text.
- text - required argument that accepts any worksheet information
The CLEAN function removes non-printable characters from text strings in Sourcetable. It was introduced to Sourcetable to help clean data that had been imported from other applications.
- The CLEAN function strips out non-printable characters from text, but does not remove extra white space characters.
- However, line breaks may be removed if they are present.
Frequently Asked Questions
What is the CLEAN function?
The CLEAN function is a function in Sourcetable that removes nonprintable characters from text. It removes the first 32 nonprinting characters in the 7-bit ASCII code.
Does the CLEAN function remove Unicode nonprinting characters?
No. The CLEAN function only removes ASCII nonprinting characters.
What information can the CLEAN function accept?
The CLEAN function will accept any Sourcetable worksheet information.