CLEAN
Use CLEAN on text imported from other applications that contains characters that may not display correctly.
Use
CLEAN( text )
Removes all non-printable characters from the text.
Parameter | Required | Description |
---|---|---|
text | Yes | the text from which to remove non-printable characters |
Returns | Text |
Use with fields
CLEAN(@LocateCustomer.out.FullName)
if field @locateCustomer.out.FullName contains non-printable characters, they will be removed and the printable characters returned