TrimSpaces function

Contents

Returns a copy of the input string without the leading and trailing spaces.

Syntax:
value = TrimSpaces (inputString ) OR value = Trim(inputString ) ' Short form usage: "Trim".

Syntax:

value = TrimSpaces (inputString )

value = Trim(inputString ) ' Short form usage: "Trim".

Parameter:	Description:
inputString	String expression that needs the spaces on the right and left to be trimmed
value	Same string expression minus the leading and trailing Space characters.

Example:
value = TrimSpaces( " Hello " ) ' Returns "Hello" value = Trim( " Hello " ) ' Returns "Hello" Results: See example comments.

value = TrimSpaces( " Hello " ) ' Returns "Hello"
value = Trim( " Hello " ) ' Returns "Hello"

See example comments.

Links:
TrimLeftSpaces, TrimRightSpaces
See Also:
Data Groups and Types

Edit Time: 9/18/2020 2:00:37 PM

Topic ID#: 37