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

Syntax

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.

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