TRIM (trimming string)

TRIM instruction removes specified characters from the beginning, ending or both ends of the variable.

Syntax

TRIM <variable> FROM |FRONT     | REMOVING |BLANK    |
                    |BACK      |          |NULL     |
                    |BOTH SIDES|          |<character>|

where

  • variable is the name of the variable, which should be modified
  • character is any character which is not BLANK and should be stripped from the string

Example


SET &STR = "***DATA*****'
TRIM &STR FROM BOTH SIDES REMOVING *

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*