Returns string with leading
characters, trailing characters, or both, removed, based on the
option you specify. The following are
valid options. (Only the capitalized letter
is needed; all characters following it are ignored.)
Both
removes both leading and trailing characters from
string. This
is the default.
Leading
removes leading characters from
string.
Trailing
removes trailing characters from
string.
The third argument, chars, specifies
the set of characters to be removed, and the default is to remove all whitespace
characters (spaces and horizontal tabs). If
chars is a null string, then no characters are
removed. Otherwise, any occurrences of the characters in chars
will be removed.
Here are some examples:
Example 7.83. Builtin function STRIP
STRIP(" ab c ")--> "ab c"STRIP(" ab c ","L")--> "ab c "STRIP(" ab c ","t")--> " ab c"STRIP("12.7000",,0)--> "12.7"STRIP("0012.700",,0)--> "12.7"STRIP("12.0000","T",'.0')--> "12"