Purpose

TRIM removes specified characters from a string.
 

Syntax

variable = TRIM (operand1,{operand2,operand3})
 

Operation

operand1 is any valid alphanumeric string
operand2 is any valid alphanumeric or wide character constant or variable specifying the characters to be removed from the string
operand3 is any alphanumeric variable with the value of A, B, D, L, R or X
variable is the resulting alphanumeric string
 

Remarks

If operand 2 and 3 are not present TRIM will remove all leading and trailing spaces from operand 1.

If operands 2 and 3 are present the TRIM process will be applied to each character specified in operand 2 independently.

The value of operand 3 will cause the following process to be applied to operand 1:

if A will remove all the characters specified in operand 2
if B will remove the leading and trailing occurrences of the characters in operand 2
if D will remove duplicated (i.e. adjacent) occurrences of characters in operand 2
if L will remove the leading occurrences of the characters in operand 2
if R will remove the trailing occurrences of the characters in operand 2
if X will remove the leading, trailing and duplicated occurrences of the characters in operand 2.
 

Example
 

 TRIM ("   ,,, Hello ,,,   "," ,",2D" ...will return... " , Hello , "