Skip to main content
Workday User Guide
Last Updated: 2023-06-23
CLEAN

CLEAN

Description

Removes all non-printable characters from the specified text string and returns the result. Non-printable characters are the ASCII numeric codes from 0 to 31. CLEAN is similar to TRIM, but TRIM also removes the space character: ASCII numeric code 32.

Syntax

CLEAN(
text
)
  • text
    : The text to remove characters from.