DriveWorks Pro 16: Trim [send feedback...]

Trim

Will remove 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.

Syntax

TRIM( [ Text] )

Text is the string of text or a reference to some text .

Examples

Rule

Meaning
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.".

Table of Contents