TRIM
Removes leading and trailing spaces from a text.
Removes leading and trailing spaces from a text.
TRIM(text)
text - the text from which the trailing paces should be removed - Value type: text
Tabs (ASCII value 9), line feed (ASCII value 10), carriage return (ASCII value 13) and blanks (ASCII value 32) are removed at the beginning and the end of the text.
Non-breakable spaces (ASCII value 160) are preserved.
