TRIM( [ Text] )
This function removes all whitespace characters between other characters that are not single space characters.
It also removes all whitespace characters present at the beginning of the string and at the end.
It does not reduce multiple single space characters to one, between non-whitespace characters.
|TRIM(" Hello, my na
me is Joe. ")
|The function removes all the whitespace at the beginning and end of the string. It also removes the tabbed character between the words "my" and "name" and it removes the newline character present in the middle of the word "name". The result is: "Hello, my name is Joe.".|