STRIP

 ──STRIP(string─┬─────────────────────────┬─)──────
                  └─,──┬────────┬─┬───────┬─┘
                       └─option─┘ └─,char─┘

STRIP removes leading and trailing characters from string based on the option you specify. Valid options (of which only the capitalized letter is significant, all others are ignored) are:

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, char, specifies the character to remove; The default is a blank. If you specify char, it must be exactly one character long.

Here are some examples:

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'

---

[Back: STREAM]
[Next: SUBSTR]