@Trim
@TRIM
removes leading or trailing white spaces.
DTP Type:
@TRIM
can be assigned to a DTP of type member, members, string, or password.
Syntax:
@TRIM(String)
Parameter:
Parameter | Description |
---|---|
String |
Design-time prompt or text |
Example:
[TRIM_ST]=@TRIM([String1])
Where:
-
[TRIM_ST]
is a DTP of type string that is not a checked prompt. -
[String1]
is a DTP of type string that is a checked prompt.
Assume that the parameter is as follows:
String: "This is a test of leading and trailing spaces"
The parameter has white spaces before and after the text. It displays as:
String1 = this is a test of leading and trailing spaces