Clean

Mon 01 January 2018

Syntax

Clean(string)

Description

Use the Clean function to remove all non-printable characters, such as control codes, end of line marks, and unpaired Unicode combining marks, from a text string and return the result as a String value. It is intended for use on text imported from other applications that contains characters that may not be printable. Frequently, low-level characters appear at the beginning and end of each line of imported data, and they cannot be printed.

Note: All white space characters (for example, a blank space, a tab, a carriage return, and so on) are deemed printable. Therefore, they are not be removed by the Clean function.

Parameters

Field or Control

Definition

string

Specifies the text to be cleaned as a string.

Returns

Returns a String value purged of non-printable characters.