TRIM
Description
Removes non-printable characters and extra spaces from text, including leading and
trailing spaces. The function replaces internal multiple spaces with a single space.
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
TRIM(
text
)
- text: The text to be trimmed.