TRIM function
Synopsis
This function
returns a string which is the passed string with the specified
character occurrences removed from the beginning and end of the
string.
Variations
TRIM(
String)
Removes all whitespace characters
from the beginning and end of the string.
Details |
Examples |
Details and examples
Parameters
String
Specifies the string which should be trimmed.
Supported types: String.
Returns
Examples
| 1. |
The following example returns "Matrox Design Assistant"
TRIM("
Matrox Design Assistant
")
|
TRIM(
String,
Characters)
Removes the specified character
occurrences from the beginning and end of the string.
Details |
Examples |
Details and examples
Parameters
String
Specifies the string which should be trimmed.
Supported types: String.
Characters
Specifies the characters that should be removed from the
beginning and end of the specified string.
Supported types: String.
Returns
Examples
| 1. |
The following example returns "rox Design Assistan"
TRIM("Matrox
Design Assistant", "Mat")
|