@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